Unix Timestamp in kdb/q

Question

Is there a built-in way of getting the Unix timestamp in kdb/q?

Something like

`float$.z.p

would be ideal; otherwise I'll have to resort to a more laborious implementation where I count the seconds from Jan 1 1970.

Manish Patel · Accepted Answer · 2014-07-13 09:21:59Z

5

q)`long$.z.p
458558447196132000
q)`long$1970.01.01D00:00
-946684800000000000

So you can get nanos from 2000.01.01. From there it's a simple calculation to convert to and from a 2000.01.01-based epoch vs 1970.01.01 based epoch.

answered Jul 13, 2014 at 9:21

Manish Patel

4,5015 gold badges31 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Awesome! thank you. For completeness, unix timestamp in kdb is q)floor((long$.z.p)-long$1970.01.01D00:00)%1e9

@nightTrevors Note that there should be a backtick prior to the word long. This backtick is hidden due to the comment format.