>>> 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?
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
