Curriculum

Course: SQL

Login

Curriculum

SQL

SQL Tutorial

0/42

SQL Database

0/20

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

MS Access Functions

0/67

SQL Quick Ref

0/1

Text lesson

Date

Example

Retrieve and return the current date of the system.

SELECT CustomerName, Date() AS CurrentDate
FROM Customers;

Definition and Usage

The DATE() function provides the current system date.

Syntax

Date()

Parameter Values

None.

Technical Details

WORKS IN

From Access 2000