Convert GMT to local - Connect_CDC - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
Latest
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
Last edition
2024-08-20
Last publish date
2024-08-20T21:40:14.000381

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.