Access: Time Function

In Access, the Time function returns the current system time.

The syntax for the Time function is:

Time ( )

The Time function returns a time stored internally as the fractional part of a double-precision number.

Examples

Time ()      returns a value such as '5:22:43 PM'

VBA Code

Dim MyTime As String  MyTime = Time

Now the MyTime variable would contain the current system time.

SQL query

You can also use the Time function in a query.

SELECT Time() AS Expr1 FROM Orders