All Forums Database
sumaps 1 post Joined 11/11
22 Aug 2016
Read Timezone Without ':' Character

I have a source data column that has a timestamp with timezone in the below format:
Mon, 5 Mar 2015 08:23:00 -0800 (PST)
I am trying to cast this as timestamp(0) with timezone FORMAT 'DD-MMM-YYYYBHH:MI:SSBB.S(F)Z'.
However this does not work because there is no ':' in the timezone. Is there a format specifier for timezone I can use to directly read this? I am keeping using a string manipulation to add a ':' to the data as the second option only if there is no format specifier to recognize timezone in the given format.
Appreciate your input.


CarlosAL 512 posts Joined 04/08
23 Aug 2016

You'll have to process the string to get a readable Teradata format (the day of month must be two digits too).
BTW: 5 Mar 2015 was not Monday.

You must sign in to leave a comment.