/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 vote294 views1 answer
Sql delete all values in a column
SQL
0 vote303 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote321 views1 answer
Oracle date winter time
SQL
3 votes258 views2 answers
Mysql sum with condition
SQL
0 vote326 views1 answer
Savepoint mysql script
SQL
27 votes368 views3 answers
Mysql delete row
SQL
7 votes305 views6 answers
Nth highest salary in sql
SQL
0 vote292 views1 answer
Replace null value within column mysql
SQL
0 vote329 views3 answers
Run sql command line
SQL
0 vote297 views1 answer
Why mysql is used?
SQL