select * from table where timefield = '2008-06-11 09:00:24.000'
gets me back 6 rows
select distinct timefield from table where timefield like '%.000'
gives me nothing
select distinct timefield from table where timefield like '2008-06-11%'
gives me nothing
select distinct timefield from table where timefield between '6/11/08' and '6/12/08'
gives me back 44 records, all of which are suffixed with ' .000 '
what am i doing wrong? can i not use LIKE on a datetime?
Start Free Trial
