Date Functions: Part 2

Common Date Functions

Date functions enhance your ability to calculate information about dates. Common DATE functions are listed in the table below. These functions operate on DATE data types and return date, date-time, or number values.



SYSDATE Function

SYSDATE is a special date function that returns the current date and time. You can use the function in any SQL statement.

SYSDATE is a function that contains no arguments. You can use SYSDATE just as you use a column name. The SYSDATE is displayed for every row in the table used.