SQL•SQL References

MS Access Date() Function

Concept visual

MS Access Date() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the current system date:

SELECT CustomerName, Date() AS CurrentDate

FROM Customers;

Definition and Usage

The Date() function returns the current system date.

Syntax

Date()

Parameter Values

None.

Technical Details

Works in:

From Access 2000

MS Access Date() Function

Concept visual

MS Access Date() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the current system date:

SELECT CustomerName, Date() AS CurrentDate

FROM Customers;

Definition and Usage

The Date() function returns the current system date.

Syntax

Date()

Parameter Values

None.

MS Access Date() Function

MS Access Date() Function

Example

Return the current system date:

Definition and Usage

Syntax

Date()

Parameter Values

Technical Details

Works in:

From Access 2000

Previous

Next

MS Access Date() Function

MS Access Date() Function

Example

Return the current system date:

Definition and Usage

Syntax

Date()

Parameter Values

Technical Details

Works in:

From Access 2000

Previous

Next