kdb Date Time Types? - Kdb+ / qStudio

Home Forums Kdb+ / qStudio kdb Date Time Types?

Tagged: ,

This topic contains 1 reply, has 2 voices, and was last updated by  John Dempster 3 years, 4 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #111184

    Oskar Morgenstern

    What Date/Time types does kdb have?

    #111185

    The date time types available in kdb are:

    char size num literal null name sql java .net
    p 8 12 dateDtimespan 0Np timestamp Timestamp DateTime (r/w)
    m 4 13 2000.01m 0Nm month
    d 4 14 2000.01.01 0Nd date date Date
    z 8 15 dateTtime 0Nz datetime timestamp Timestamp DateTime*(read only)
    n 8 16 00:00:00.000000000 0Nn timespan Timespan TimeSpan
    u 4 17 00:00 0Nu minute
    v 4 18 00:00:00 0Nv second
    t 4 19 00:00:00.000 0Nt time time Time TimeSpan

    Our cheat sheet includes the full data types table:
    http://www.timestored.com/kdb-guides/kdb-reference-card

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.