/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 vote208 views1 answer
Sql comparison operators
SQL
4 votes229 views1 answer
Id increment ms sql server
SQL
0 vote226 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote221 views1 answer
In mysql workbench contnent not feching
SQL
7 votes214 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote549 views1 answer
Sql field equals multiple values
SQL
0 vote221 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote223 views1 answer
Xampp import sql file command line
SQL
0 vote218 views1 answer
Multiple left join mysql
SQL
18 votes189 views2 answers
How to get all the tables displayed in oracle
SQL