FORMAT_DATETIME
Converts a datetime value into a string.
Syntax
Arguments
Examples
Transformation job example
SQL
Query result
Last updated
Name | Type | Description | Default Value |
---|---|---|---|
datetime | format | Output |
---|---|---|
datetime | format | Output |
---|---|---|
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
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
timestamp '2017-09-25 22:11:00'
'yyyy/MM/dd HH:mm:ss.SSS'
2017/09/25 22:11:00.000