Convert GMT to local - 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 to local

Function name:   gmt_to_local

Parameter list:    (CHAR input timestamp)

Return type:    CHAR

What the method does:    Converts a Greenwich Mean Time (GMT) timestamp to local time 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.

Note: The default offset that is used is the one set on the host where the kernel is running. However, this offset may not always be the same as the host for an off-box server. For example, you may have a host, in the Eastern time zone, with all the off-box servers in a Central timezone.