1 Reply Latest reply on Jan 2, 2013 10:47 AM by Joan Puig-Oracle

    Convert Local Date and Time into GMT

      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.
        • 1. Re: Convert Local Date and Time into GMT
          Joan Puig-Oracle
          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.