/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

1 vote210 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote211 views1 answer
Procedures sql insert mysql
SQL
0 vote193 views1 answer
Postgresql find missing id
SQL
1 vote189 views1 answer
Foreign key constraint in ms sql
SQL
10 votes188 views2 answers
Sql merge statement
SQL
0 vote212 views1 answer
Reset keys in sql
SQL
0 vote210 views1 answer
Rename constraint postgresql
SQL
0 vote205 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote228 views4 answers
What is unique key in sql
SQL
1 vote193 views1 answer
Oracle get current schema
SQL