Posted by laredotornado on 03/08/06 05:15

Hi,

I have a MySQL column that's of a DATETIME type. What MySQL function
can I apply to it in a SELECT statement to make the time midnight? FOr
example, if a value of the column was

2006-03-07 21:00:00

I'd like to apply a MySQL function and make the value

2006-03-07 00:00:00

THanks for your help, - Dave

[Back to original message]