Differences

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

oracle-to-mysql:to_char_datetime [September 23, 2014 1:24 pm]
sqlines
oracle-to-mysql:to_char_datetime [September 23, 2014 1:24 pm] (current)
sqlines
Line 48: Line 48:
| 2 | TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') | DATE_FORMAT(SYSDATE(), '%Y%m%d%H%i%s') | | 2 | TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') | DATE_FORMAT(SYSDATE(), '%Y%m%d%H%i%s') |
| 3 | TO_CHAR(SYSDATE, 'DD-MON-YYYY') | DATE_FORMAT(SYSDATE(), '%d-%b-%Y') | | 3 | TO_CHAR(SYSDATE, 'DD-MON-YYYY') | DATE_FORMAT(SYSDATE(), '%d-%b-%Y') |
-| 4 | TO_CHAR(SYSDATE, 'RRRR-MM-DD') | DATE_FORMAT(SYSDATE(), %Y-%m-%d') |+| 4 | TO_CHAR(SYSDATE, 'RRRR-MM-DD') | DATE_FORMAT(SYSDATE(), '%Y-%m-%d') |
===== Database and SQL Migration Tools ===== ===== Database and SQL Migration Tools =====