/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 vote359 views1 answer
Oracle select partition
SQL
0 vote345 views1 answer
Codigo crear tablas sql server
SQL
0 vote391 views1 answer
Apt install sql server
SQL
2 votes302 views1 answer
Mysql admin u root p password change password
SQL
0 vote369 views1 answer
Csv to sqlite python
SQL
1 vote296 views1 answer
Unique vs distinct sql
SQL
0 vote333 views1 answer
Difference between varchar and varchar2
SQL
0 vote365 views1 answer
Normalization in database
SQL
0 vote357 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
1 vote361 views1 answer
Alphabetical order mysql
SQL