/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

4 votes375 views2 answers
Tsql utf to local time
SQL
0 vote357 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote381 views1 answer
Geopoint from json mysql function
SQL
0 vote385 views1 answer
Vbscript connect mssql
SQL
24 votes400 views6 answers
Alter table name sql
SQL
0 vote326 views1 answer
How to install Firebird
SQL
0 vote325 views1 answer
Postgres get running query
SQL
0 vote400 views1 answer
Contraint default SQL
SQL
0 vote306 views1 answer
Ms sql print more than 1 variable
SQL
0 vote365 views1 answer
How to create a new db from dumb file mysql
SQL