Timezone support for Date/Timestamp data types
Posted: Mon Oct 29, 2007 9:09 am
Hi,
I was wondering if there is anyway to extract(or load) records of date/timestamp/time datatypes with *timezone* information. My Database fields for date/time have timezone information associated with them, but when I use datastage timestamp/date datatypes it gets truncated.
Other way round, when I use sequential file to load data into database, sequential file does not recognize timestamp/time datatypes with timezone information(say +5-30).
If I use varchar data type to extract time/timestamp fields in sequential file and then try to convert it into timestamp in Modify stage (before supplying it to ODBC stage) then also I could not find any datastage function that supports timezone information.
I was wondering if there is anyway to extract(or load) records of date/timestamp/time datatypes with *timezone* information. My Database fields for date/time have timezone information associated with them, but when I use datastage timestamp/date datatypes it gets truncated.
Other way round, when I use sequential file to load data into database, sequential file does not recognize timestamp/time datatypes with timezone information(say +5-30).
If I use varchar data type to extract time/timestamp fields in sequential file and then try to convert it into timestamp in Modify stage (before supplying it to ODBC stage) then also I could not find any datastage function that supports timezone information.