GETDATE¶

Returns the current date and time of the system.

Note

This function is provided for SQL Server compatability.

Syntax¶

GETDATE() --> DATETIME

Arguments¶

None

Returns¶

The current system date and time, with type DATETIME.

Notes¶

Aliases to this function include CURRENT_TIMESTAMP and SYSDATE.
To get the date only, see CURRENT_DATE.

Examples¶

Get the current system date and time¶

master=> SELECT CURRENT_TIMESTAMP, CURRENT_TIMESTAMP(), SYSDATE, GETDATE();
getdate             | getdate0            | getdate1            | getdate2
--------------------+---------------------+---------------------+--------------------
2019-12-07 23:04:26 | 2019-12-07 23:04:26 | 2019-12-07 23:04:26 | 2019-12-07 23:04:26

Find events that happen before this month¶

We will use TRUNC to get the date at the beginning of this month, and then filter.

master=> SELECT COUNT(*) FROM cool_dates WHERE dt <= TRUNC(GETDATE(), month);
count
-----
 5