Date_part mysql

mysql> SELECT EXTRACT(YEAR FROM '2019-07-02');
        -> 2019
mysql> SELECT EXTRACT(YEAR_MONTH FROM '2019-07-02 01:02:03');
        -> 201907
mysql> SELECT EXTRACT(DAY_MINUTE FROM '2019-07-02 01:02:03');
        -> 20102
mysql> SELECT EXTRACT(MICROSECOND
    ->                FROM '2003-01-02 10:30:00.000123');
        -> 123

Similar codes

0 vote277 views1 answer
Sql server port 1434
SQL
4 votes269 views1 answer
Oracle error compilation line
SQL
1 vote260 views2 answers
Mysql update table from another table
SQL
0 vote293 views1 answer
Show the colums of table sql
SQL
1 vote278 views2 answers
Mysql error 1215
SQL
0 vote291 views1 answer
Plsql find location of procedure
SQL
1 vote301 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote279 views1 answer
Regex any word except sql
SQL
0 vote308 views1 answer
Create a view in sqlite
SQL
6 votes306 views3 answers
Create database mysql utf8
SQL