Oracle Timezone conversions

[amit punekar]

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.
SELECT FROM_TZ(CAST(TO_DATE('1999-12-01 11:00:00', 'YYYY-MM-DD HH:MI:SS') AS TIMESTAMP), 'America/New_York') AT TIME ZONE 'America/Los_Angeles' "West Coast Time" FROM DUAL;

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.

Regards,
Amit

[amit punekar]

Hello,
Used the following entries for respective countries.
1) Mauritius - Indian/Reunion
2) Botswana - AFRICA/JOHANNESBURG
3) Ghana - UTC

regards,
Amit