Returns the system time as a character string in HH:MM:SS or HH:MM:SS.hh format.

Syntax

TIME([<exp>])

<exp>

Any expression, which causes TIME( ) to return the current time to the hundredth of a second.

Description

TIME( ) returns a character expression that is your computer system’s current time. If you do not pass TIME( ) an expression, it returns the current system time in HH:MM:SS format, where HH is the hour, MM the minutes, and SS the seconds.

If you pass TIME( ) an expression, it returns the current system time in HH:MM:SS.hh format, where .hh is hundredths of a second. The type and value of the expression you pass to TIME( ) has no effect other than to make it include hundredths of a second.

To change the system time, use SET TIME.