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

    Convert Local Date and Time into GMT

    947140
      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.

          http://www.techonthenet.com/oracle/functions/from_tz.php
          http://www.techonthenet.com/oracle/functions/tz_offset.php

          I hope it helps.

          Joan