/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 vote138 views1 answer
Oracle concat datetime
SQL
1 vote134 views1 answer
Show per page table in xampp
SQL
0 vote117 views1 answer
Get only first row mysql
SQL
1 vote136 views1 answer
Oracle nvl2
SQL
7 votes134 views3 answers
Python and mysql connectivity
SQL
0 vote134 views1 answer
Mysql milliseconds
SQL
0 vote139 views1 answer
Set engine to innodb
SQL
3 votes138 views1 answer
Oracle user quota on tablespace
SQL
0 vote118 views1 answer
Change database name psql 8
SQL
11 votes130 views1 answer
How to get ddl for materialized view
SQL