|
|
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.
|
|
KDB+ Related Tutorials |
|
---|---|
Perl Scripting Tutorial | Python Tutorial |
Adv Java Tutorial | Database Testing Tutorial |
Unix/Linux Tutorial |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.