Oracle
| Function Name | Description |
|---|---|
| CURRENT_DATE | Obtains the current date value. |
| CURRENT_TIMESTAMP | Obtains the current date, time, and timestamp in the local time zone. |
| DBTIMEZONE | Obtains the time zone of the database. |
| EXTRACT(<interval> FROM <expression>) | Evaluates the expression and returns the requested interval (year, month, day, etc.). |
| LOCALTIMESTAMP | Obtains the current date and time in the local time zone. |
| MONTHS_BETWEEN(<expression1>, <expression2>) | Calculates the months and fractions of months between expression2 and expression1. |
| NEW_TIME(<expression>, <timezone1>, <timezone2>) | Evaluates the date expression as though it is the first time zone and returns the date in the second time zone. |
| NEXT_DAY(<expression>, <dayname>) | Evaluates the expression and returns ... |
Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
