Convert different time zone data into PST

[PrajS]

Hi Experts,

I have 'event created ' datetime column and time zone name of the that event. I want to show this   date time column in PST.

Can be during load or on analytics . Need help 

Tried convert_tz , that shows null as data is not available in time zone table . Looking for an alternative solution.

Thank you 

[zesid_8756]

Use the time zone converter for this purpose

[MayilVahanan]

HI @PrajS 

You can use ConvertToLocalTime() function to convert the time zone.

For ex: ConvertToLocalTime(Now(), 'GMT-07:00') or ConvertToLocalTime(UTC(), 'GMT-07:00')