dynamobi/dynamobi — Issue #700: [FRG-172] timestamps are sometimes returned in local timezones and sometimes in GMT
Author: dynamobi-build
Created: 2011-12-30 03:43:55+00:00
State: open
Labels: Catalog, FRG

[reporter="schoi", created="Wed, 26 Jul 2006 18:55:56 -0500 (GMT-05:00)"]
examples:

-- this returns time in GMT:

values ("CURRENT_TIMESTAMP");

-- creation_timestamp is in PDT:

select table_name, creation_timestamp from sys_root.dba_tables;

But there is no timezone specified in the timestamp values returned. I thought we were storing the timestamp in GMT always?