Q Language Temporal Data - KDB+

What is Q Language Temporal Data?

The q language has many unique methods of representing and manipulating temporal information inclusive of times and dates.


A date in kdb+ is internally saved because the integer quantity of days because our reference date is 01Jan2000. A date after this date is internally saved as a nice variety and a date before that is referenced as a bad number.

By default, a date is written within the layout “YYYY.MM.DD”

Arithmetic and logical operations can be performed directly on dates.

The 1st of January 2000 fell on a Saturday. therefore any Saturday all through the history or within the future when divided by using 7, might yield a remainder of 0, Sunday gives 1, Monday yield 2.


A time is internally saved because the integer number of milliseconds because the stroke of midnight. A time is written inside the format HH:MM:SS.MSS

As in case of dates, arithmetic can be carried out at once on times.


A datetime is the aggregate of a date and a time, separated by using ‘T’ as inside the ISO standard layout. A datetime value stores the fractional day matter from midnight Jan 1, 2000.

The underlying fractional day count can be obtained by casting to float.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

KDB+ Topics