I have a requirement where I have 2 columns column 1 holds a timestamp value and column 2 holds time zone for ex +03:00 I have to combine both of these and insert into a column of type timestamp with time zone.
I was trying the following query but it was not working (sql assistant)
SEL CAST(CURRENT_TIMESTAMP AS TIMESTAMP WITH TIME ZONE FORMAT 'YYYY-MM-DDBHH:MI:SSDS(F)Z')
result is 5/15/2010 21:42:06.097000 where I was expecting it like 2010-05-15 21:42:06.097+00:00
any ideas to acheive this would be appreciated.
P.S: If its because of the settings please let me know which settings are to be changed.