|
|
Archives of the TeradataForum
Message Posted: Thu, 21 Dec 2006 @ 20:54:55 GMT
Subj: | | Re: Converting TIMESTAMP From GMT to EST |
|
From: | | PriceJ |
Michael Larkins wrote:
| Since you have not told us whether or not the time includes the time zone, I will simply tell you that you do INTERVAL time math to adjust
the time by the 5 hours between EST and UTC (Universal Time Coordinate - old GMT). If it does contine a time zone you normalize using
CAST. | |
The timestamp columns are all simply TIMESTAMP(0) format in the tables. Would we need to alter the table to achieve what you describe?
Thanks,
Jackson
Jackson Price
American Red Cross
Data Warehouse & Decision Support Systems
| |