Differences

This shows you the differences between two versions of the page.

oracle-to-mysql:trunc_datetime [April 06, 2017 11:09 pm]
sqlines
oracle-to-mysql:trunc_datetime [August 24, 2017 11:33 am] (current)
sqlines
Line 49: Line 49:
| | **Oracle** | **MySQL** | | | **Oracle** | **MySQL** |
-| 1 | TRUNC(SYSDATE) | DATE_DATE(SYSDATE()) |+| 1 | TRUNC(SYSDATE) | DATE(SYSDATE()) |
| 2 | TRUNC(SYSDATE, 'DD') | DATE(SYSDATE()) | | 2 | TRUNC(SYSDATE, 'DD') | DATE(SYSDATE()) |
| 3 | TRUNC(SYSDATE, 'MM') | DATE_FORMAT(SYSDATE(), '%Y-%m-01') | | 3 | TRUNC(SYSDATE, 'MM') | DATE_FORMAT(SYSDATE(), '%Y-%m-01') |