Posted by Chandra on 10/01/15 11:17

Hi
just try it this way:

SELECT *
FROM stat
WHERE
data > convert(varchar(10),'2005-05-24 14:07:28',101) ORDER BY id Asc

best Regards,
Chandra
http://groups.msn.com/SQLResource/
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Query to compare table data between Test and Production?
• Prev in forum: Re: Permissions with views and tables
• Thread view: Re: datatime error

[Reply to this message]