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