Convert column with unix timestamp from UTC to a different time zone

1 vote

1 answer

790 views

                          Good afternoon,

I have a column within one of my tables that is stamped with a UNIX timestamp. I would like to have the return in my current timezone, PST. I have the following query and the below error is being returned. Any help would be greatly appreciated as I'm not sure if I am missing something simple, or way off base. 

    select TO_TIMESTAMP_TZ (('1970-01-01','YYYY-DD-MM;) + NUMTODSINTERVAL (table_name,'SECOND'),'UTC')) at time zone 'PST' 
    from column_name

    ORA-00907:missing right parenthesis
    00907.00000 - "missing right parenthesis"
    *Cause:
    *Action:
    Error at Line 16 Column:37. 
                        

Asked by tdavidson (13 rep)

Apr 20, 2023, 08:30 PM
Last activity: Apr 21, 2023, 08:05 AM

Convert column with unix timestamp from UTC to a different time zone

Related Questions