Date and time Query - problem
- by Gold
hi
i try to run this query:
select * from WorkTbl
where ((Tdate = '20100414' AND Ttime = '06:00') and (Tdate <= '20100415' AND Ttime <= '06:00'))
i have this date: 14/04/2010 and time: 14:00
i cant see hem, how to fix the query ?
thank's in advance