>>>>> 2004-09-03 08:00 --> 2004-09-03 00:00
>>>>> 2004-09-03 14:00 --> 2004-09-03 00:00
>>>>> 2004-09-03 15:01 --> 2004-09-04 00:00
>>>>
>>>> SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS
>>>> DATE) FROM table
>>>
>>> At first glance this looks good and the MySQL docs seem to support
>>> this theory but it just throws an error.
>>
>> Which version are you running?
>
> 4.1.3
Does the following work:
SELECT MessageDate + INTERVAL 11 HOUR AS DATE
FROM table
Then you can use date_format to set the hours to zero.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
