Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: time zone related problem

Re: time zone related problem

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 18 Sep 2006 08:54:20 -0700
Message-ID: <1158594860.416243@bubbleator.drizzle.com>


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

In what version of Oracle?

My crystal ball is broken as is the Ouija board. Can you provide an example of what you mean by convert?

-- 
Puget Sound Oracle Users Group
Received on Mon Sep 18 2006 - 10:54:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US