/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 vote152 views1 answer
Psql check table fields
SQL
0 vote138 views1 answer
Foreign key type uniqu mysql
SQL
0 vote138 views5 answers
Linq cheat sheet
SQL
0 vote152 views2 answers
Dbms interview questions
SQL
0 vote142 views1 answer
Like and not like together in sql
SQL
6 votes153 views1 answer
Allsource oracle
SQL
1 vote148 views1 answer
Base64 encode sql server
SQL
0 vote153 views3 answers
Sql parenthetical expression examples
SQL
6 votes143 views1 answer
Postgres get size of database
SQL
1 vote141 views1 answer
Oracle update with sequence
SQL