Timestamps in nanoseconds

TrevorHall
Registered Posts: 15 ✭✭✭✭
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?
Answers
-
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!