Temporal Type and Conversion
Temporal variables in DolphinDB have the following data types:
Data Type |
Example |
---|---|
date |
2013.06.13 |
month |
2012.06M |
time |
13:30:10.008 |
minute |
13:30m |
second |
13:30:10 |
datetime |
2012.06.13 13:30:10 or 2012.06.13T13:30:10 |
timestamp |
2012.06.13 13:30:10.008 or 2012.06.13T13:30:10.008 |
nanotime |
09:00:01.000100001 |
nanotimestamp |
2016.12.30T09:00:01.000100001 |
We can use temporal functions to convert a temporal data type into another temporal data type:
$ month(2016.02.14);
2016.02M
$ date(2012.06.13 13:30:10);
2012.06.13
$ second(2012.06.13 13:30:10);
13:30:10
$ timestamp(2012.06.13 13:30:10);
2012.06.13T13:30:10.000