Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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)

ArgumentTypeDescription
valueAnyValue to be converted.
dateFormatString

An optional parameter which is a

date format pattern

Date and Time Format Patterns. 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)

Returns the string "14462" where the attribute in.value contains a value 14462.


toString(in.value)

Returns the string "0" where the attribute in.value contains a value 0.00000008.


toString(_fromDate,"dd MMMM yyyy, HH:mm:ss")

...

Returns the two digit format of seconds of the date and time. This is the string "07" where _fromDate contains a value of "20090324.150507".

toString(_fromDate,"z")

Returns the time zone of the date. This is the string "GMT" for a UK date.


toString(_fromDate,"Z")

Returns the time zone offset/id of the date. This is the string "+0000" for a UK date.

Date Format Pattern

The following values are available for use in dateFormat patterns:

...

The number of letters used in the pattern determines the format.

...

GMT date, or "+0100" for British Summer Time.

See Also