/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

2 votes222 views1 answer
How to insert string variable into sqlite database
SQL
53 votes336 views6 answers
Sql server alter column
SQL
0 vote225 views1 answer
How to get table current identity value in sql server
SQL
2 votes218 views1 answer
Oracle trace file
SQL
0 vote215 views1 answer
Find most frequent value in SQL column
SQL
3 votes222 views2 answers
Mysql config user password
SQL
1 vote219 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote211 views1 answer
MySql count occurences more than"
SQL
5 votes222 views4 answers
Restart the psql server windows
SQL
0 vote210 views1 answer
No suitable driver found for sqlite
SQL