DATETIME_PARSE({UNIXTIME},'x', 'EST')

I think your problem is the locale modifier you’re using; ‘EST’ doesn’t seem to be valid. (To be honest, I didn’t know DATETIME_PARSE() even supported a third variable; it’s optional.) AFAIK, the ‘locale’ option doesn’t do anything with the timezone, as such — that is, I don’t think it will take a datetime value (presumably at some standard timezone and shift it appropriately for the locale; it controls such things as spelling of the day of the week and culturally appropriate formats.

A list of acceptable locale modifiers can be found here — or, unless you have a specific need for it, just leave it off.

To force a timezone, you need to use SET_TIMEZONE(), typically in conjunction with DATETIME_FORMAT().

I’m having the same issue here.
I’ve tried everything suggested here as well-

Just throws errors. 13 digit unix timecode. Just need a formula to convert to D/M/YYYY in (what I’m assuming is automatically determined as) PST timezone

Nevermind :slightly_smiling_face: I think the problem I had was that I was trying to parse a string field rather than an integer. Once I converted the source column, it works great!