• No replies
1 Post

Pinned topic Interpreting Unix timestamp

‏2009-11-05T11:06:15Z |
I am using Impromptu to query an Oracle data table that uses numeric fields to hold date/time information.

The fields contain a Unix timestamp - milliseconds since 1/1/70.

Is there any way of using Impromptu functions to convert these into meaningful dates?

As an example, 1257325343000 converts to 4-Nov-2009 09:02:23