Weird Timestamp in Googlesheet

I’m currently getting 1596229758 for the timestamp in my googlesheet. What format is this? and is there a way to convert it to something normal?

it’s unix timestamp.

unix timestamp is very polular way to present date and time because it’s easy to calculate a difference between two times. but it’s not human-readable.

you can convert it with custom code block but you may need to know about timezone.

this might be help.

Thanks for the info! I ended up using Zapier to convert it in my googlesheet