/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 vote204 views1 answer
Sql set max value in column
SQL
1 vote204 views1 answer
Select if then postgresql
SQL
9 votes202 views2 answers
Get first 3 letters in sql
SQL
0 vote201 views1 answer
Get foreign table names mysql
SQL
0 vote197 views1 answer
Oracle archivemode
SQL
0 vote215 views1 answer
Mariadb cast null to 0
SQL
0 vote210 views1 answer
Sql declare variable single line
SQL
9 votes205 views3 answers
Show table columns mysql command line
SQL
0 vote209 views1 answer
Csv to sqlite python
SQL
3 votes210 views1 answer
Unsigned int in mysql
SQL