FORMAT_DATETIME
Convert datetime into string
FORMAT_DATETIME(datetime, format)
Name | Type | Description | Default Value |
---|---|---|---|
datetime | timestamp | A datetime value. | |
format | string | A format string that is compatible with JodaTime’s pattern: http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html | |
datetime | format | Output |
---|---|---|
timestamp '2017-09-25 22:11:00' | 'yyyy/MM/dd HH:mm:ss.SSS' | 2017/09/25 22:11:00.000 |
timestamp '2018-03-10 08:12:45' | 'yyyy/MM/dd' | 2018/03/10 |
timestamp '2019-10-20 08:55:12.450' | 'HH:mm:ss.SS' | 08:55:12.45 |
timestamp '2018-03-10 08:55:12.450' | 'E' | Sat |
CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
SELECT datetime, format,
FORMAT_DATETIME(datetime, format) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET datetime = timestamp '2017-09-25 22:11:00',
format = 'yyyy/MM/dd HH:mm:ss.SSS'
WHERE time_filter()
LIMIT 1;
datetime | format | Output |
---|---|---|
timestamp '2017-09-25 22:11:00' | 'yyyy/MM/dd HH:mm:ss.SSS' | 2017/09/25 22:11:00.000 |
Last modified 28d ago