As per my business logic, I am getting timestamp in UTC format in a column. While loading to my target table, I want to load in PST. I cannot just add/subtract hours from it since I need to consider day light saving into account. Could someone help me with any function available in Teradata to convert the same.
Solved! Go to Solution.
How does the source data look like?
Is the target column a Timestamp with or without time zone?
What is your system/session time zone?
Thanks Dieter. It worked. Just curious to know is there any system table which has list of timestamp formats like 'America Pacific'.