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