PhixFlow Help

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Function: toString()

Converts a value into a string.

Returns NULL if value is NULL.

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)

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

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

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.

  • Text: If the number of pattern letters is 4 or more, the full form is used; otherwise a short or abbreviated form is used if available.
  • Number: The minimum number of digits. Shorter numbers are zero-padded to this amount.
  • Year: Numeric presentation for year and weekyear fields are handled specially. For example, if the count of 'y' is 2, the year will be displayed as the zero-based year of the century, which is two digits.
  • Month: 3 or over, use text, otherwise use number.
  • Zone: 'Z' outputs offset without a colon, 'ZZ' outputs the offset with a colon, 'ZZZ' or more outputs the zone id.
  • Zone names: Time zone names ('z') cannot be parsed.
  • Any characters in the pattern that are not in the ranges of ['a'..'z'] and ['A'..'Z'] will be treated as quoted text. For instance, characters like ':', '.', ' ', '#' and '?' will appear in the resulting time text even they are not embraced within single quotes.

See Also

  • No labels