Re: time zone related problem

uday wrote:
> I have to convert given time from "EST" to any of the following
> timezones
> Poland
> Etc/GMT-3
> ACT
> Etc/GMT-2
> Etc/GMT-10
> GMT
> Etc/GMT-9
> Etc/GMT-1
> CET
> CST
> Etc/GMT+6
> US/Pacific
> EST
> PST
> AGT
> Hongkong
>
> I cannot use java stored-procedure {the JAVA support is not installed
> at the production server}
>
> I have to use it from within oracle tried using new_time but
> not-supporting all above timezone
>
>
> some-body please help
>

Have you looked into setting your session's time zone?

ALTER SESSION SET time_zone = 'time_zone_region';

The following doc shows this command:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2012.htm#i2277774

Have your application set this for the user. Then you won't need to convert the data is it will automatically be converted to the session's time zone.

Or then again...maybe the above does not meet your needs.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown