Access: Time Function

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

The syntax for the Time function is:

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

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

Dim MyTime As String 
MyTime = Time

Now the MyTime variable would contain the current system time.

You can also use the Time function in a query.

SELECT Time() AS Expr1 
FROM Orders

Related Posts