concatDateTime

Syntax

concatDateTime(date, time)

Alias: concatDT

Arguments

date is a scalar/vector of data type DATE.

time is a scalar/vector of data type SECOND, TIME or NANOTIME.

If date and time are both vector,s they must have the same length.

Details

Combine date and time into one new variable.

If time is SECOND, return DATETIME.

If time is TIME, return TIMESTAMP.

If time is NANOTIME, return NANOTIMESTAMP.

Examples

concatDateTime(2019.06.15,13:25:10);
// output
2019.06.15T13:25:10

concatDateTime(2019.06.15,[13:25:10, 13:25:12, 13:25:13]);
// output
[2019.06.15T13:25:10,2019.06.15T13:25:12,2019.06.15T13:25:13]

date=[2019.06.18, 2019.06.20, 2019.06.21, 2019.06.19, 2019.06.18, 2019.06.20]
time = [09:34:07,09:36:42,09:36:51,09:36:59,09:32:47,09:35:26]
sym = `C`MS`MS`MS`IBM`IBM$SYMBOL
price= 49.6 29.46 29.52 30.02 174.97 175.23
qty = 2200 1900 2100 3200 6800 5400
t = table(date, time, sym, qty, price);

select concatDateTime(date,time) as datetime, sym, qty, price from t;
datetime sym qty price
2019.06.18T09:34:07 C 2200 49.6
2019.06.20T09:36:42 MS 1900 29.46
2019.06.21T09:36:51 MS 2100 29.52
2019.06.19T09:36:59 MS 3200 30.02
2019.06.18T09:32:47 IBM 6800 174.97
2019.06.20T09:35:26 IBM 5400 175.23