Date Conversion Function Localtime to UTC (Java Wrapper)
- From: <Andreas.Haunschmidt@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 May 2005 07:59:47 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
