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