SQL•SQL References

MS Access Now() Function

Concept visual

MS Access Now() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the computer system's current date and time: 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()

Parameter Values

None.

Technical Details

Works in:

From Access 2000

MS Access Now() Function

Concept visual

MS Access Now() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the computer system's current date and time: 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.

MS Access Now() Function

MS Access Now() Function

Example

Definition and Usage

Syntax

Now()

Parameter Values

Technical Details

Works in:

From Access 2000

Previous

Next

MS Access Now() Function

MS Access Now() Function

Example

Definition and Usage

Syntax

Now()

Parameter Values

Technical Details

Works in:

From Access 2000

Previous

Next