Differences

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

oracle-to-mysql:to_date [September 24, 2014 1:44 pm]
sqlines
oracle-to-mysql:to_date [September 24, 2014 1:49 pm] (current)
sqlines
Line 42: Line 42:
Typical conversion examples: Typical conversion examples:
-| **Oracle** | **MySQL** | +| | **Oracle** | **MySQL** | 
-| TO_DATE('2013-02-11', 'YYYY-MM-DD') | STR_TO_DATE('2013-02-11', '%Y-%m-%d) | +| 1 | TO_DATE('2013-02-11', 'YYYY-MM-DD') | STR_TO_DATE('2013-02-11', '%Y-%m-%d) | 
-| TO_DATE('11/02/13', 'DD/MM/RR') | STR_TO_DATE('11/02/13','%d/%m/%y') | +| 2 | TO_DATE('11/02/13', 'DD/MM/RR') | STR_TO_DATE('11/02/13','%d/%m/%y') |  
 +| 3 | TO_DATE('20140924', 'YYYYMMDD') STR_TO_DATE('20140924', '%Y%m%d') |
===== Database and SQL Migration Tools ===== ===== Database and SQL Migration Tools =====