You should probably use the 'DATEFORMAT' function instead of 'convert'.
"By three methods we may learn wisdom: First, by reflection, which is noblest; Second, by imitation, which is easiest; and third by experience, which is the bitterest."
-Confucius
Comment on Re: Not able to find dateTime value using sql