Thursday, May 9, 2019

Convert Date Field Time Zone to a Different Time Zone via ODBC

Normally create date and last modified date field of Custom records, Support Cases, Transactions, Item Demand Plans and Item Supply Plans are stored in GMT time zone when called via ODBC.

To convert the Time Zone to a different one, use the sample query below:

SELECT to_char(new_time(create_date, 'GMT', 'EST'),'MM/DD/YY HH:MI AM') AS DATE_CREATED FROM Administrator.SUPPORT_INCIDENTS

1 comment:

  1. is there a reference to the timezone codes, eg: EST, PST etc?