/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 vote125 views1 answer
Oracle get current schema
SQL
2 votes134 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote132 views1 answer
How to find top 3 salary in sql
SQL
4 votes140 views1 answer
Postgresql create table with index
SQL
0 vote119 views1 answer
What is the essence of SQL?
SQL
1 vote127 views1 answer
Mysql text to decimal
SQL
1 vote136 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
39 votes230 views5 answers
Sql drop column
SQL
0 vote122 views1 answer
Top frequency in sql server
SQL
2 votes169 views1 answer
Select from array in psql
SQL