kdb Date Time Types?

[Oskar Morgenstern]

What Date/Time types does kdb have?

[John Dempster]

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

[Author]

Posts