Groups | Blog | Home
all groups > sql server (alternate) > february 2004 >

sql server (alternate) : MySQL between times


Gary
2/13/2004 12:16:23 AM
Hello,

I want to COUNT all records between TODAY 12:00:00am and Now().

Select *
where TIMESTAMP BETWEEN TODAY 12:00:00am AND Now()


How do I do this? Not sure how to specify TODAY, 12:00am.

Thanks,

Gary.

sql NO[at]SPAM hayes.ch
2/13/2004 1:05:11 AM
[quoted text, click to view]

This is a Microsoft SQL Server (MSSQL) newsgroup, so you will probably
get a better answer in a MySQL newsgroup.

AddThis Social Bookmark Button