toString

Owned by Former user (Deleted)
Last updated: Jul 23, 2020 by Fiona Sargeant (Unlicensed)



Function: toString()

Converts a value into a string.

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 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"

Remember that to specify a standard day-month-year string, use dd-MM-YYYY. If you specify DD-MM-YYYY, PhixFlow returns the day in the year.

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 string "03 September 2010, 13:04:07" where _fromDate contains a value of "20100903.130407".


toString(_fromDate,"yyyy-MM-dd HH-mm-ss")

Returns the string "2010-09-03 13-04-07" where _fromDate contains a value of "20100903.130407".


toString(_fromDate,"dd M yyyy")

Returns the string "19 9 2010" where _fromDate contains a value of "20100919.120000".


toString(_fromDate,"dd MMM yyyy")

Returns the string "19 NOV 2010" where _fromDate contains a value of "20101119.120000".


toString(_fromDate,"dd MMM YYYY hh mm ss")

Returns the string "19 NOV 2010 12 00 00" where _fromDate contains a value of "20101119.120000".


toString(_fromDate,"dd MMM YYYY h m s")

Returns the string "19 NOV 2010 12 0 0" where _fromDate contains a value of "20101119.120000".


toString(_fromDate,"d MMM YY h m s")

Returns the string "19 NOV 10 12 0 0" where _fromDate contains a value of "20101119.120000".


toString(_fromDate,"d M Y h m s")

Returns the string "19 11 2010 12 0 0" where _fromDate contains a value of "20101119.120000".


toString(_fromDate,"G")

Returns the era of the date. This is the string "AD" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"C")

Returns the century of era of the date. This is the string "20" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"w")

Returns the week in year of the date. This is the string "13" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"e")

Returns the day of week of the date as a number. This is the string "2", for Tuesday, where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"E")

Returns the first three characters of the day of week of the date. This is the string "Tue" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"EEEE")

Returns all the characters of the day of week of the date. This is the string "Tuesday" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"y")

Returns the year of the date. This is the string "2009" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"yy")

Returns the last two characters of the year of the date. This is the string "09" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"yyyy")

Returns all the characters of the year of the date. This is the string "2009" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"Y")

Returns the year of era of the date. This year of era is always greater than or equal to zero. This is the string "2009" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"YY")

Returns the last two digits of the year of era of the date. This year of era is always greater than or equal to zero. This is the string "09" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"YYYY")

Returns the year of era of the date. This year of era is always greater than or equal to zero. This is the string "2009" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"D")

Returns day of year of the date. This is the string "83" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"MMM")

Returns the first three characters of the month of the date. This is the string "MAR" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"MMMM")

Returns all the characters of the month of the date. This is the string "March" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"M")

Returns the month of the date in the number format. This is the string "3" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"d")

Returns the single digit format of the day of month of the date. This is the string "8" where _fromDate contains a value of "20090308.150507".


toString(_fromDate,"dd")

Returns the two digit format of the day of month of the date. This is the string "24" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"a")

Returns the halfday (AM/PM) of the date and time. This is the string "PM" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"K")

Returns the single digit format of the hour of the halfday (0~11) of the date and time. This is the string "3" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"KK")

Returns the two digit format of the hour of the halfday (0~11) of the date and time. This is the string "03" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"h")

Returns the single digit format of the clockhour of the halfday (1~12) of the date and time. This is the string "3" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"hh")

Returns the two digit format of the clockhour of the halfday(1~12) of the date and time. This is the string "03" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"H")

Returns the single digit format of the hour of the day (0~23) of the date and time. This is the string "6" where _fromDate contains a value of "20090324.060507".


toString(_fromDate,"HH")

Returns the two digit format of the hour of the day (0~23) of the date and time. This is the string "15" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"k")

Returns the single digit format of the clockhour of the day (1~24) of the date and time. This is the string "9" where _fromDate contains a value of "20090324.090507".


toString(_fromDate,"kk")

Returns the two digit format of the clockhour of the day (1~24) of the date and time. This is the string "09" where _fromDate contains a value of "20090324.090507".


toString(_fromDate,"m")

Returns the single digit format of the minutes of the date and time. This is the string "5" where _fromDate contains a value of "20090324.150507".


toString(_fromDate,"mm")

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


toString(_fromDate,"s")

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


toString(_fromDate,"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 offset/id of the date. This is the string "+0000" for a UK GMT date, or "+0100" for British Summer Time.

See Also