Re: Converting dates to UTC?

Ian Parkin wrote:
>
> Oracle's implementation of SQL gives you the ability to translate to/from
> any timezone that you please - easiest method being to add/subtract a GMT
> offest (ie 'SELECT sysdate + <GMT OFFSET>. FROM dual' will give you the
> date/time that your require).

How to take care of DSTs? The query:

        SELECT my_date + <GMT_OFFSET> FROM my_table will give wrong results if there is dates (my_date) in different DST. In other words, <GMT_OFFSET> cannot be constant.

>
> To be honest, I have never worked out a fully portable solution across all
> platforms and would be more than interested in a fool-proof SQL-based solution.
>
> IAP
Me too!

-- 

Timo Haatainen
Carelcomp Forest Oy