THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Now() Function

❮ MS Access Functions

Example

Return the current system date and time:

SELECT CustomerName, Now() AS CurrentDateTime
FROM Customers;
Try it Yourself »

Definition and Usage

The Now() function returns the current system date and time.

Syntax

Now()

Parameter Values

None.

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

❮ MS Access Functions