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 vote219 views1 answer
How to remove default in mysql
SQL
6 votes630 views3 answers
Sql select last id
SQL
0 vote249 views1 answer
On delete set default
SQL
1 vote237 views1 answer
Postgres check for foreign key
SQL
0 vote224 views4 answers
How to drop all tables in sql
SQL
0 vote243 views1 answer
Drop CHECK constraint sql
SQL
1 vote262 views1 answer
Opensuse restart MySQL
SQL
1 vote248 views1 answer
Wherein mysql
SQL
0 vote228 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote275 views1 answer
Wordpress make wp user in db
SQL