Convert GMT using offset - Connect_CDC - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Method:    Convert GMT using offset

Function name:   gmt_to_local

Parameter list:    (CHAR input timestamp, CHAR GMT offset))

Return type:    CHAR

What the method does:    Converts a Greenwich Mean Time (GMT) timestamp and a specified offset to local time. Specify the offset in one of the following formats:

  • +hh:mm

  • -hh:mm

where:

  • - or +–the amount to subtract or add

  • hh–the hours to add or subtract from GMT

  • mm–the minutes to add or subtract from GMT

The local time is returned in the following format:

yyyy-mm-dd hh:mm:ss:ffffff

where:

  • yyyy–the year

  • mm–the month

  • dd–the date

  • hh–the hour, in a 24-hour clock (for example, 20 is 8:00 pm)

  • mm–minutes

  • ss–seconds

  • ffffff–fractions of a second

If the timestamp input is an empty string, an empty string is returned.

For example, if:

  • GMT timestamp is 2010-12-19 12:00:00:000000

  • Actual local time is 2010-12-19 07:00:00:000000

  • Specified offset is -03:00 hours

The returned local time is: 2010-12-19 04:00:00:000000