What is the correct way to create tables with date types?

Community Support
1

What is the correct way to create tables with date types?

q)tt:(d:2019.05.262019.05.25`2019.04.01; j:1 2 3)

q)tt

d          j

2019.05.26 1

2019.05.25 2

2019.04.01 3

q)meta tt

c| t f a

-| -----

d| s    

j| j    

q)tt:(d:“D”$“2019.05.26” “D”$“2019.05.25” “D”$“2019.04.01”; j:1 2 3)

q)tt

d j

  1

  2

  3

q)

2

( d: 2019.05.26 2019.05.25 2019.04.01; j:1 2 3)

3

It can be done directly as the other response stated. It is also possible to use symbols or strings, as you attempted. With strings, you can cast (tok) the list of strings in one operation:

([]d:"D"$("2019.05.26";"2019.05.25";"2019.04.01"); j:1 2 3)

Similarly, if you have symbols you can cast the symbols to strings and do the same:

([]d:"D"$string 2019.05.262019.05.252019.04.01; j:1 2 3)`