SQL•SQL References

MS Access Now() Function

Example

  SELECT CustomerName, Now() AS CurrentDateTime
FROM Customers;

Definition and Usage

The Now() function returns the current date and time based on the computer's system date and time.

Syntax

Now()

None.

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

  SELECT CustomerName, Now() AS CurrentDateTime
FROM Customers;

The Now() function returns the current date and time based on the computer's system date and time.

Syntax

Now()

None.

Works in:	From Access 2000