October 23, 2012 at 2:11 pm
I have a datetime column which has lots of these values:
2012-10-29 00:00:29.000
2011-10-15 00:00:29.000
2012-11-12 00:00:29.000
2013-01-16 00:00:29.000
2010-11-18 00:00:29.000
2012-08-19 06:33:00.000
2012-10-13 03:73:00.000
2012-01-18 02:63:00.000
How do I not select rows which have "00:00:22.000" in the hh:mm:ss:mmm as their value?
October 23, 2012 at 2:33 pm
select * from sometable where cast(datetime_column as time) = '00:00:22:000'
October 23, 2012 at 3:01 pm
I just saw your signature line, David. Are you quoting Heisenberg?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 23, 2012 at 3:49 pm
Could be. I'm uncertain...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy