Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 2, 2013 4:47 AM by
Convert Local Date and Time into GMT
Dec 30, 2012 11:19 PM
In Oracle how to convert date & time in GMT. Suppose the input will be local date & time e.g. ‘IN’, ‘15/11/2010 15:20:30’ ( country Code, DD/MM/YYYY Hr:Min:Sec in 24hr format) output should be in GMT format.
This content has been marked as final.
Show 1 reply
Re: Convert Local Date and Time into GMT
Jan 2, 2013 4:47 AM
in response to
I don't think this should be in the OLAP subforum. At least try to look for the correct section before posting next time.
Apart from that, you can try a combination of the From_Tz and Tz_Offset functions.
I hope it helps.