Time functions

You can use the time functions DAY, MONTH, WEEKDAY, and YEAR in either the Projection clause or the WHERE clause of a query. These functions return a value that corresponds to the expressions or arguments that you use to call the function. You can also use the CURRENT or SYSDATE function to return a value with the current date and time, or use the EXTEND function to adjust the precision of a DATE or DATETIME value.