Converting a column containing UTC values to EST values in Snowflake

I am trying to convert a column that contains UTC values to EST values.

Expected output:

Approach tried:

SELECT LOAD_DATE_UTC, CAST(LOAD_DATE_UTC AS TIMESTAMP_LTZ(9)) AS LOAD_DATE_EST FROM TABLE_A 

The above approach seem to be returning the same value as is. Please advise how I can convert the column to EST values which is set as Local Time Zone at Snowflake configuration level

2 Answers

I believe the idea is to convert to EST (target)- So following approach will suit: CONVERT_TIMEZONE( <source_tz> , <target_tz> , <source_timestamp_ntz> )

SELECT LOAD_DATE_UTC, CONVERT_TIMEZONE(LOAD_DATE_UTC,'America/New_York',LOAD_DATE_UTC::timestamp_ntz) FROM TABLE_A 

try using convert_timezone.

select '2022-03-23 20:59:51.000' as EST, convert_timezone('UTC', '2022-03-23 20:59:51.000') as utc_time_zone;