Thanks Red,
The function worked for us , I was using wrong time zone initially.
I was looking for a time in EST format so initially I used EST as a time zone for e.g.
“FROM_UTC_TIMESTAMP(date_ts,‘EST’) which gave me results without Daylight saving. Then when we tried ‘America/New_York’ as a time zone it worked.
“FROM_UTC_TIMESTAMP(date_ts, ‘America/New_York’)
Thanks
Dinesh