> > table
> or if you're not fortunate enough to have standards compliant
> db like postgres, say sql server:
> SELECT
> CAST(CONVERT(char(12),DATEADD(minute,541,yourDateColumn),101) AS
> smalldatetime) AS yourNewDateTime
Unfortunately even after converting the DATEADD function to DATE_ADD (as
used by MySQL) this solution produces the same error as Jochems solution.
--
Jay
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]