/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 vote332 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
1 vote325 views1 answer
Tsql random number
SQL
3 votes379 views1 answer
What is having
SQL
0 vote308 views1 answer
Check sql query executed wp
SQL
0 vote341 views1 answer
Mysql update even / odd rows
SQL
1 vote333 views1 answer
Mysql remove last empty newline
SQL
5 votes352 views1 answer
Mysql last day of next month
SQL
0 vote378 views1 answer
Create a plsql object
SQL
2 votes338 views1 answer
How to check grants on a package in oracle
SQL
3 votes363 views1 answer
Oracle list privileges
SQL