Search code examples
datekdb

How to input a date later than 2290.12.31 in KDB?


I'm using KDB+ 3.2 (32-bit), and I can't seem to execute an expression with a date greater than 2290.12.31:

q) 2291.01.01
An error occurred during execution of the query.
The server sent the response:
2291.01.01

Any ideas why and how to fix?


Solution

  • Since dates are stored as integer internally, I was able to create the 2291.01.01 using below.

    q)\`date$106285  
    2290.12.31  
    q)\`date$106286  
    2291.01.01  
    q)type `date$106286  
    -14h