Re: sysdate, Time Zones and GMT

> In article <803213757snx_at_johnw.supreme.auug.org.au> John Wright writes:
 

> I need to be able to store date/time information in an Oracle v7 database in
> GMT (Grenich Mean Time) also known as UTC.
> [...]
> The application is to be deployed across multiple timezones, yet all data
> input, output and processing must be done on the same timezone basis, ie GMT.

How about setting system clock on server(s) to GMT? This is cleanest solution.

If not an option, you could store the offset from system clock time to GMT (in hours) in a table. Add the offset to SYSDATE when inputting and processing. You have to manage the offset: whenever system clock is adjusted for daylight savings time (or equivalent) the offset must be adjusted simultaneously.

> Apart from writing a 'C' function call, and invoking it everytime I want to
> use a date/time, does anyone have any experience/work arounds?

How about a PL/SQL stored function? Callable directly from SQL in ORACLE 7.?. Received on Fri Jun 16 1995 - 00:00:00 CEST