What Does The Timestamp Function Do In Notion?
Benefit Of Using The Unix Timestamp
This timestamp does not change due to location on the globe. Computers use the unix timestamp to utilize time without timezone complications. As for Notion, the best use for the timestamp function is for dates that aren't currently being used in the database.
Decoding The Timestamp Functions
timestamp(date property): 1620157140000 (13 digit number)
fromTimestamp(1620157140000): May 4, 2021 3:48 PM
Use-Case For Timestamp Function
For example, if I want to find how many days are between now and December 5th, 2018, I don't have to create a date property with this date in order to make the formula work. Instead, I can determine what timestamp aligns with December 5th, 2018 and work from there.
Step 1: Find timestamp of December 5th, 2018 with formula called "Temporary Date"
timestamp(prop("Temporary Date"))
= 1543986000000
Step 2: Find days between December 5th, 2018 and today with this formula:
dateBetween(now(), fromTimestamp(1543986000000), "days")
= 881
Limitation Of Timestamp
Inside Notion, the timestamp function does not read seconds in a date with time. It stops at minutes as a result of how time is read in the program. This is why using timestamps to create unique IDs may be tricky. The user must wait one minute between database entries to generate true unique numbers.