SQL compare time part of datetime field
C / C++ / MFC
2
Posts
2
Posters
0
Views
1
Watching
-
hi how can i compare time part of datetime field in SQL, for exaple : time of datetimefield between '12:24:36' and '18:50:25' thank you :rose:
SELECT xxx FROM xxx WHERE datetimefield BETWEEN #01/01/1970 12:24:36# AND #12/31/2038 18:50:25#
I had to do the opposite once where I wanted rows for a particular day, regardless of the time. I used:
SELECT xxx FROM xxx WHERE datetimefield BETWEEN #02/13/2004 00:00:00# AND #02/13/2004 23:59:59#
A rich person is not the one who has the most, but the one that needs the least.