CAST(TO_DATE(To_Char({today}, ‘YYYY-MM-DD HH24:MI:SS’), ‘YYYY-MM-DD HH24:MI:SS’) AS TIMESTAMP) AT TIME ZONE ‘America/New_York’
CAST(TO_DATE(To_Char({today}, ‘YYYY-MM-DD HH24:MI:SS’), ‘YYYY-MM-DD HH24:MI:SS’) AS TIMESTAMP) AT TIME ZONE ‘America/New_York’