The SMS/800 TFN Registry stores ALL Date Time in UTC timezone, hence SQL queries executed through SFTP/SQL*Net will return data in UTC timezone. Users have to convert UTC to the desired timezone in the query.
The following SQL statement can be used to convert (which shows UTC to CST conversion):
- to_char(<column_name>,'mm/dd/yyyy hh12:mi am') statusChangeDate_in_utc,
to_char(from_tz(cast( statusChangeDate as timestamp(6)),'UTC') at time zone 'CST','mm/dd/yyyy hh12:mi am')