Re: timezone ?

Perry,

If you just want to do date conversion, you can try this

for example:

SELECT NEW_TIME(sysdate,'EST','GMT') from dual;

to convert Eastern Standard Time to GMT, or

SELECT NEW_TIME(sysdate,'EDT','GMT') from dual;

to convert Eastern Daylight Time to GMT.

similar, to do date conversion duirng insert a record , try this

INSERT INTO <table_name> VALUES (NEW_TIME(sysdate, 'EDT', 'GMT'));

Chadwick

perry ¼g¹D¡G

> If I put a date into oracle, is it stored as I specified it, or is it
> converted
> from my "local" timezone to another (eg, GMT), before it is saved ?
>
> Does Oracle have a concept of local timezone ?
>
> (I noticed that new_time seems to imply there is no predefined local
> timezone, as you specify it for each call to new_time)
>
> Thanks for any info...
>
> - Perry
Received on Tue Apr 11 2000 - 00:00:00 CDT