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

[BobBannanas]

I keep getting ERROR code

My formula is DATETIME_PARSE({UNIXTIME},‘x’, ‘EST’)

How can I convert a 13 digit unix time stamp into a date like this: 2/7/2019 8:09pm

I have this:1549584840000
I need this: 2/7/2019 8:09pm

[W_Vann_Hall]

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().

[Spencer_Allen]

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

Format Unix timestamp as human readable date Ask the community

Using Buffer (through Zapier) I get a Unix timestamp for when each post is scheduled. An example Unix timestamp is 1497503280. The expected human readable equivalent is 15/6/2017 3:08pm (for Australian Eastern Standard Time which is GMT +10). Using a formula based on Excel convert (via https://www.epochconverter.com/), the nearest I can get to seeing the output in a human readable form is by: DATETIME_PARSE( ( ( {BufferUnixTimeStamp} +36000 ) / 86400 ) +25569 ) This doesn’t work as all it p…

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

[Spencer_Allen]

BobBannanas:

DATETIME_PARSE({UNIXTIME},‘x’, ‘EST’)

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!