...
Returns NULL if value is NULL.
Numbers will be given to a maximum of 6 decimal places. If greater precision is required please use format.
Syntax
toString(value, dateFormat)
| Argument | Type | Description |
|---|---|---|
| value | Any | Value to be converted. |
| dateFormat | String | An optional parameter which is a date format pattern. PhixFlow will check if the value parameter is a date or can be converted to a date. If the value parameter cannot be converted to a date then an error will be thrown. If this parameter is not used and a date object is passed into the value parameter, PhixFlow will use the default format of "yyyyMMdd.HHmmss" |
Examples
toString(in.value)
...
The following values are available for use in dateFormat patterns:
| Symbol | Meaning | Presentation | Examples |
|---|---|---|---|
| G | era | text | AD |
| C | century of era (>=0) | number | 20 |
| Y | year of era (>=0) | year | 1996 |
| YY | year of era (>=0) | year | 96 |
| YYYY | 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 | Tue |
| EEEE | day of week | text | Tuesday |
| y | year | year | 1996 |
| yy | year | year | 96 |
| yyyy | year | year | 1996 |
| D | day of year | number | 189 |
| M | month of year | month | 7 |
| MM | month of year | month | 07 |
| MMM | month of year | month | JUL |
| MMMM | month of year | month | JULY |
| d | day of month | number | 5 |
| dd | day of month | number | 05 |
| a | halfday of day | text | PM |
| K | hour of halfday (0~11) | number | 3 |
| KK | hour of halfday (0~11) | number | 03 |
| h | clockhour of halfday (1~12) | number | 5 |
| hh | clockhour of halfday (1~12) | number | 05 |
| H | hour of day (0~23) | number | 6 |
| HH | hour of day (0~23) | number | 06 |
| k | clockhour of day (1~24) | number | 9 |
| kk | clockhour of day (1~24) | number | 09 |
| m | minute of hour | number | 5 |
| mm | minute of hour | number | 05 |
| s | second of minute | number | 7 |
| ss | second of minute | number | 07 |
| 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 for text | delimiter | |
| '' | single quote | literal | ' |
The number of letters used in the pattern determines the format.
...