Miliseconds to Date

Technical Help
1

I was using this formula in aritable that calulated DATE from a milisecond stamp.

DATEADD(‘1/1/1970’,FIELD/1000,‘seconds’)

I cannot find the way to do it in baserow.

¿Can you help?

2

Hi @headblue ,

You can achieve this by combining the following functions:

add(
  todate('19700101', 'YYYYMMDD'), // '1/1/1970' date from your example
  date_interval(
    concat(field('Miliseconds') / 1000, ' seconds') // You need to rename the 'Miliseconds' field to your own field name
  )
)
3

Awesome thanks Alex,

Alex

1 Like