Date functions
| Function | mysql | postgre | oracle | Description |
|---|---|---|---|---|
| ADD_MONTHS(d, n) |
 |
uses + or - |
|
Date d plus n months |
| LAST_DAY(d) | Last day of the month containing date d | |||
| MONTHS_BETWEEN(d, e) | x | x |
|
Months between dates d and e |
| NEXT_DAY(d, weekday) | The first weekday (mon, tue, etc.) after d | |||
| NEW_TIME(d, z1, z2) | Convert date/time d from time zone z1 to z2 | |||
| ROUND(d[, fmt]) |
|
|
|
d rounded on fmt (the default for fmt is midnight) |
| TRUNC(d[, fmt]) | d truncated on fmt (the default for fmt is midnight) | |||
| EXTRACT(c FROM d) |
|
|
|
Extract date/time component c from expression d |
| Sysdate | Returns the current operating system date from database server |