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.