64-bit integer

[KimmoLinna]

Hi,

I am importing data from kdb+ with qconnect. I would like handle timestamp but I don’t know how to read 64-bit integer with ⎕DR, because 643 ⎕DR is missing. Does someone remember how to combine two 323 ⎕DR numbers (32-bit signed integers) into one 64-bit signed integer?

Best regards,

Kimmo

[KimmoLinna]

The solution was quite simple when I realised kdb+ uses ones' complement system for negative numbers.

To64Int←{{⎕ml←3⋄(∊8⍴⊂(8⍴1),0){{1⊃⍵:-2⊥~⍵⋄2⊥⍵}∊⌽⍺⊂⍺\⍵}⍵}11 ⎕DR ⍵}

Best regards,

Kimmo