Time function

Returns a Variant (Date) indicating the current system time.

Syntax

Time

Remarks

To set the system time, use the Time statement.

Query examples

Expression	Results
SELECT Time() AS Expr1 FROM ProductSales GROUP BY Time();	Returns the current system "Time" for in the system Time format and displays in the column Expr1.
SELECT Time() AS CurrentTime FROM ProductSales GROUP BY Time();	Returns the current system "Time" for in the system Time format and displays in the column CurrentTime.

VBA example

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

This example uses the Time function to return the current system time.

Dim MyTime
MyTime = Time    ' Return current system time.

See Also

Choose the right date function