RT (Request Tracker) Date Handling

[Simon Taylor]

Hi Scott,

> Is there some way I can add 11 hours in the query in mySql
>
> eg:
> 	UNIX_TIMESTAMP(LastUpdated) + (11 * 3600) as uts
>
> Scott

Try this as an illustration:

  SELECT now(), now() + INTERVAL 11 HOUR;

And in your case:

  SELECT UNIX_TIMESTAMP(LastUpdated) + INTERVAL 11 HOUR;

Regards,

Simon
-- 
Unisolve Pty Ltd - Melbourne, Australia
+61 3 9568 2005