CONVERT_DATETIME
This page describes the CONVERT_DATETIME function in Lenses SQL.
CONVERT_DATETIME (strExpr, fromPattern, toPattern)
Converts the string format of a date [and time] to another using the pattern provided.
Available in:
Sample code:
USE `kafka`;
SELECT
CONVERT_DATETIME(tpep_pickup_datetime, 'yyyy-MM-dd HH:mm:ss', 'dd-MM-yyyy HH:mm'),
tpep_pickup_datetime
FROM nyc-yellow-taxi-trip
LIMIT 1;
Output:
{
"value": {
"CONVERT_DATETIME": "01-01-2016 00:00",
"tpep_pickup_datetime": "2016-01-01 00:00:02"
}
}