11 Replies Latest reply on Aug 29, 2016 3:04 PM by Jan Paulo salvador

    Time format conversion?  Think it might be Unix?

    Mark ODonnell

      I have an oracle table with data that looks like this stored as a string:

      00000000000000000001472493607010

      00000000000000000001472493604077

      00000000000000000001472493564987

      00000000000000000001472493563653

      00000000000000000001472493561164

      00000000000000000001472493559325

      00000000000000000001472493558825

      00000000000000000001472493558600

      00000000000000000001472493555603

      00000000000000000001472493553029

      00000000000000000001472493553028

      00000000000000000001472493553027

      00000000000000000001472493553026

      00000000000000000001472493553025

       

      From what I have been told this is zulu format time stamp, but all my tests so far show this most likely is unix time format.

      I was wondering if someone could share a calculation that works to format this as a usable Tableau date/time format?

      Thanks.