SYSDATE

Returns the current date and time of the system.

Note

This function is provided for Oracle compatability and is called without parentheses.

Syntax

SYSDATE --> DATETIME

Arguments

None

Returns

The current system date and time, with type DATETIME.

Notes

• This function has a special form and is called without parentheses.

• Aliases to this function include CURRENT_TIMESTAMP and GETDATE.

• 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(SYSDATE, month);
count
-----
 5