CURRENT_DATE and NOW

Get today's date and current time.

CURRENT_DATE

CURRENT_DATE returns today's date; CURRENT_TIMESTAMP returns date and time. They take no arguments.

SELECT CURRENT_DATE AS bugun;

This query returns today's date.

The expression CURRENT_DATE AS bugun is evaluated and returned.

Some databases use CURDATE() or GETDATE(). The ANSI standard is CURRENT_DATE. It can also be a default column value.

Select today's date aliased as bugun.

Today

SELECT ____ AS bugun;

Show answer

SELECT CURRENT_DATE AS bugun;

Next lesson: EXTRACT