Free cookie consent management tool by TermsFeed totime() Function
totime() Function

Function

totime( value )

Converts a value to Time.

See also: time()

Parameters

Keyword Type Description

value

Any Type

Value to convert.

Returns

Time

Usage considerations

Using the value parameter

The value parameter accepts Integer, Decimal (double precision floating point), and Datetime, and Array data types.

Using totime() with arrays

When operating on arrays, it is not necessary to use apply with totime. If multiple parameters are passed, or one parameter is an Array, totime will return a Time Array.

Understanding results

To return a localized time for a user, the local() function must be nested within the totime() function.

For example, totime(local(pp!starttime)) returns the localized time when a given process started. Otherwise the time is returned in GMT. This is true unless the user happens to reside in the GMT timezone, then no localization is necessary.

Examples

totime(datetime(2005,12,13,12,0,0)) returns 12:00 PM

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Compatible
Offline Mobile Compatible
Sync-Time Custom Record Fields Compatible

Can be used to create a custom record field that only evaluates at sync time.

Real-Time Custom Record Fields Incompatible
Process Reports Compatible
Process Events Compatible

totime() Function

FEEDBACK