Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to use .year inside function in KDB?

Tags:

kdb

q-lang

I would like to use dot notation to extract the year of a date.

q) myDate:2014.01.01;
q) myDate.year
2014i           / works OK

But when inside a function,

f:{[x] :x.year};
f[myDate]

I get an error (I use Studio for KDB+)

An error occurred during execution of the query.
The server sent the response:
x.year

What's going wrong?

like image 272
mchen Avatar asked Apr 16 '14 18:04

mchen


1 Answers

As per this page on code.kx, this behavior is a quirk of q. To get around this, you can use the cast function.

q)f:{[x] :`year$x}
q)f[myDate]
2014i
like image 84
jgleeson Avatar answered Oct 01 '22 22:10

jgleeson