Timestamps in nanoseconds

TrevorHall
Level 3
Timestamps in nanoseconds

I have datasets containing UNIX timestamps. The timestamps are expressed in nanoseconds, either as an ordinal number or decimal (ex: "1597679162072270261" or "1597672733.1572235") The built-it processor allows for seconds or milliseconds. How do I process nanosecond timestamps?

0 Kudos
1 Reply
Liev
Dataiker Alumni

Hi @TrevorHall 

In a formula step you could divide by 1,000,000 the value of the timestamp before processing with the processor you mention.

Good luck!