How to convert time to number?

#1

how to convert time to number

#2

What kind of number?

#3

convert now to total seconds

#4

Total seconds since? 1/1/1970?

#5

I get it, thanks

#6

I’m interested in this too… basically, I want to join a RowID with the earliest of the dates (just a basic date+time) to create a relation, but I’m not comfortable with joining the time in a text format.
What would be the best to convert the date-time including millisecs to a reasonably short but stable number or text? Like the UNIX timestamp?

PS: With this, I’m using a cool trick to limit my ledger to max 10 items then the earliest is overwritten…

#7

What I usually do is use a math column to convert it to a numerical form. Something like:

YEAR(T)*10000+MONTH(T)*100+DAY(T)

With T being the timestamp in question. That will give me a format of YYYYMMDD.

If you want minutes, hours and seconds, just add the relevant params into the formula.

2 Likes