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 vote139 views1 answer
Mysql a from on this page has
SQL
0 vote130 views1 answer
Pl sql join 3 tables
SQL
1 vote127 views1 answer
Importance of comment in mysql
SQL
1 vote143 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
1 vote124 views2 answers
DROP TABLes regardless of constraints
SQL
4 votes132 views3 answers
Sql find second highest salary employee
SQL
-1 vote132 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote141 views2 answers
T SQl Checking Your Username
SQL
0 vote210 views1 answer
Mysql disable triggers
SQL
1 vote164 views1 answer
Mysql view current queries
SQL