in reply to Not able to find dateTime value using sql
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
In Section
Seekers of Perl Wisdom