File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes Oracle Timezone conversions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle Timezone conversions" Watch "Oracle Timezone conversions" New topic

Oracle Timezone conversions

amit punekar
Ranch Hand

Joined: May 14, 2004
Posts: 507
Hello there,
I have a table that stores a COUNTRY and particular TIMESTAMP for the same.
Now in the SQL I need to select this entry and convert it into GMT timestamp. I came across one SQL that can do this for me at this location.

Now to provide the Timezone I referred the Oracle view "V$TIMEZONE_NAMES". The countries for which I need to convert the timezone is "Ghana", "Botswana" and "Mauritius" which cannot be located in there.

Appreciate your suggestion.

amit punekar
Ranch Hand

Joined: May 14, 2004
Posts: 507
Used the following entries for respective countries.
1) Mauritius - Indian/Reunion
3) Ghana - UTC

I agree. Here's the link:
subject: Oracle Timezone conversions
Similar Threads
f:convertDateTime and data type conversion
TimeStamp.toString() does not work as expected
Date comparision in SQL from timestamp
Retrieving wrong date/time with Timestamp
Convert Local time to UTC and vice versa