Timestamps in nanoseconds

TrevorHall
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

  • Liev
    Liev Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭

    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!

Setup Info
    Tags
      Help me…