Description
Convert datetime field to ISO-8601 string or a custom date time format.
Syntax
ToString(Datetime_field)
ToString(Datetime_field, formatString)
Arguments
datetime_field - datetime expression.
formatString - format of the custom string. See below for formatting information.
Format strings
Symbol | Meaning | Presentation | Examples |
---|---|---|---|
G | era | text | AD |
C | century of era (>=0) | number | 20 |
Y | year of era (>=0) | year | 1996 |
x | weekyear | year | 1996 |
w | week of weekyear | number | 27 |
e | day of week | number | 2 |
E | day of week | text | Tuesday; Tue |
y | year | year | 1996 |
D | day of year | number | 189 |
M | month of year | month | July; Jul; 07 |
d | day of month | number | 10 |
a | halfday of day | text | PM |
K | hour of halfday (0~11) | number | 0 |
h | clockhour of halfday (1~12) | number | 12 |
H | hour of day (0~23) | number | 0 |
k | clockhour of day (1~24) | number | 24 |
m | minute of hour | number | 30 |
s | second of minute | number | 55 |
S | fraction of second | number | 978 |
z | time zone | text | Pacific Standard Time; PST |
Z | time zone offset/id | zone | -0800; -08:00; America/Los_Angeles |
\' | escape character | for a-z/A-Z | T |
\'\' | single quote | literal single quote | ' |
Based on http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html
Examples
ToString(ToDate('2013-10-17T00:00:00.000Z'),'MM-dd-yy') returns a string 10-17-13
ToString(ToDate('2013-10-17T00:00:00.000Z'), 'yyyy-MM-dd\'T\'HH:mm:ss')
returns a string 2013-10-17T00:00:00
Return value datatype
string
Impact of null value
If either parameter is null or not provided, returns null.