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

-1 vote292 views2 answers
How to select the lowest values from table per client sql
SQL
8 votes310 views2 answers
Mysql get first x characters
SQL
3 votes301 views3 answers
Sql last week
SQL
6 votes283 views1 answer
Update left join mysql
SQL
7 votes293 views3 answers
Restore postgres database from sql file
SQL
0 vote317 views1 answer
Best sql collation
SQL
0 vote292 views1 answer
Mysql find db contarint
SQL
0 vote278 views1 answer
Wordpress sql change site url
SQL
1 vote290 views2 answers
Create a unqie constraint mysql
SQL
0 vote330 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL