CREATE DATASET mydataset ( id: int, name: string, date: datetime ) PRIMARY KEY id;
id,name,date 1,John Smith,2018-05-01T12:30:00.000Z 2,Jane Doe,2018-04-15T15:20:00.000Z
SELECT datetime('2018-05-01 12:30:00', 'yyyy-MM-dd HH:mm:ss')
示例代码:
CREATE DATASET mydataset ( id: int, name: string, date: datetime ) PRIMARY KEY id;
LOAD DATASET mydataset USING localfs ( ("path"="path/to/my/csvfile.csv"), ("format"="csv"), ("delimiter"=","), ("datetime-format"="yyyy-MM-dd'T'HH:mm:ss.SSS'Z'") );
SELECT datetime('2018-05-01 12:30:00', 'yyyy-MM-dd HH:mm:ss');
参考链接:https://groups.google.com/g/asterixdb-user/c/8GkLyi5HnTQ.