Date Conversion Function Localtime to UTC (Java Wrapper)

From: <Andreas.Haunschmidt_at_voestalpine.com>
Date: Wed, 11 May 2005 07:59:47 +0200
Message-ID: <0F639AFBF6850240BCBADA6887DDDFCF02040B4C@mail02.vastahl.net>

Dear list members,

I'm looking for 2 functions like this:

  FUNCTION local2UTC(iDATE IN DATE)
  RETURN DATE IS

• Returns UTC for iDATE in localtime BEGIN ... END;

and the inverse function
=20
  FUNCTION UTC2local(iDATE IN DATE)
  RETURN DATE IS

• Returns localtime for iDATE in UTC BEGIN ... END;

Someone told me there is a Java class (java.calender) which could help doing that. It should be possible then to use it in PL/SQL (server side Oracle 9.2) by wrapping it.

As I'm not a Java specialist and in order not to reinvent=20 the wheel, I'm hoping someone could give me a hint, or=20 - much appreciated:) - sample code.

Thanks in advance

--

Andreas
--

http://www.freelists.org/webpage/oracle-l Received on Wed May 11 2005 - 02:04:22 CDT