gmt date - how?

Hi,

I want to use a date field with gmt time, something like

insert into mydatetable values ('17-Jun-1999 13:30:00 GMT') <- please note the 'GMT' characters...

Unfortunately I did not find any information about how to define timezones in Oracle. I can set the NLS_DATE_FORMAT to match the format of the date inserted into a datefield record, but Oracle seems not to support a different time zone apart from the default.

I just want a client program (WinNT) to decide how the date should be converted for finally viewing the table data, but the date itself should be GMT in the database. How can I do so? Is there a way to determine the local time zone? I found a function called NEW_TIME that converts date to different time zones, but this function does not tell me how the date field is internally stored in oracle. I'd like to have it internally stored in GMT and not CET (here in Germany...)

Any Ideas?

thanks
gerry Received on Thu Jun 17 1999 - 06:36:32 CDT