/SQL/Disallowed function mysql to_date()

Disallowed function mysql to_date()

DATE_FORMAT(STR_TO_DATE

mysql> Select STR_TO_DATE('22.10.2017',GET_FORMAT(DATE,'EUR'))AS 'EUROPEAN FORMAT';
+-----------------+
| EUROPEAN FORMAT |
+-----------------+
| 2017-10-22      |
+-----------------+
1 row in set (0.00 sec)

Source: tutorialspoint.com

Disallowed function mysql to_date()

        
            
        
     SELECT STR_TO_DATE('21,5,2013','%d,%m,%Y');

Source: mysqltutorial.org

Similar codes

0 vote299 views1 answer
Oracle exchange subpartition
SQL
0 vote288 views1 answer
Sqlite3 update select
SQL
0 vote268 views1 answer
Oracle right characters
SQL
0 vote250 views1 answer
Grant owner postgresql
SQL
10 votes294 views3 answers
Join multiple tables sql
SQL
1 vote284 views1 answer
How do you use sql in you company
SQL
0 vote292 views2 answers
Sqlalchemy core in clause
SQL
0 vote259 views1 answer
Linux upload database to mysql
SQL
0 vote282 views1 answer
Sauvegarde complète my sql
SQL
0 vote281 views1 answer
Plpgsql coalesce equivalent for empty string
SQL