/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 vote337 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote329 views1 answer
No query unable to fetch row sqlite
SQL
0 vote328 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote378 views1 answer
Sql doesn't contain
SQL
0 vote321 views3 answers
Sql delete all except
SQL
0 vote314 views2 answers
Sql 2 way of select unique
SQL
1 vote303 views2 answers
How to check username in mysql command line
SQL
7 votes310 views1 answer
Set sequence value oracle
SQL
0 vote318 views1 answer
Oracle list subpartitions
SQL
0 vote335 views1 answer
Sql server rtrim everything after character
SQL