Time.ToText
Time.ToText(time as nullable time, optional options as any, optional culture as nullable text) as nullable text
Returns a textual representation of time
. An optional record
parameter, options
, may be provided to specify additional properties. culture
is only used for legacy workflows. The record
can contain the following fields:
Format
: Atext
value indicating the format to use. For more details, go to Standard date and time format strings and Custom date and time format strings. Omitting this field or providingnull
will result in formatting the date using the default defined byCulture
.Culture
: WhenFormat
is not null,Culture
controls some format specifiers. For example, in"en-US"
"tt"
is"AM" or "PM"
, while in"ar-EG"
"tt"
is"ص" or "م"
. WhenFormat
isnull
,Culture
controls the default format to use. WhenCulture
isnull
or omitted, Culture.Current is used.
To support legacy workflows, options
and culture
may also be text values. This has the same behavior as if options = [Format = options, Culture = culture]
.
Convert #time(01, 30, 25)
into a text
value. Result output may vary depending on current culture.
Usage
Time.ToText(#time(11, 56, 2))
Output
"11:56 AM"
Convert using a custom format and the German culture.
Usage
Time.ToText(#time(11, 56, 2), [Format="hh:mm", Culture="de-DE"])
Output
"11:56"
Convert using standard time format.
Usage
Time.ToText(#time(11, 56, 2), [Format="T", Culture="de-DE"])
Output
"11:56:02"