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

• Next in forum: Re: Guestbook with multiple host-pages
• Prev in forum: Re: INSERT A ROW
• Thread view: how to truncate a MySQL date

[Reply to this message]