The TimeToText function is a built-in function that converts Time t to a text value in the format "hh:mm:ss".

Input parameters

t: Time Type

Output parameters

Text Type

Examples

Usage

Result

TimeToText( #12:30:34# )

"12:30:34"

TimeToText( #2015-07-02 12:30:34# )

"12:30:34"

Remarks

You should check the limits of the Time data type.

See Also

TextToDateValidate Function | Available Conversion Functions to Text | Available Built-in Functions