/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 vote123 views1 answer
Sqlalchemy filter relationship
SQL
0 vote165 views1 answer
Postgresql like
SQL
4 votes184 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote197 views1 answer
Duplicate value unique constraint mysql error
SQL
13 votes163 views4 answers
Mysql get last row
SQL
0 vote186 views1 answer
Mysql insert into select with recursive
SQL
0 vote170 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote170 views1 answer
Mysql trim characters
SQL
21 votes174 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote171 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL