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 vote203 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote231 views1 answer
Postgres week number
SQL
1 vote262 views1 answer
Alter database datafile maxsize 32g
SQL
31 votes218 views3 answers
Sql count
SQL
0 vote217 views1 answer
Postgresql find missing id
SQL
1 vote222 views1 answer
Mysql dump specific tables
SQL
1 vote226 views1 answer
Postgres set column based on another column
SQL
1 vote217 views2 answers
Sql select only row with the max date
SQL
1 vote210 views1 answer
Postgres get timestamp
SQL
0 vote236 views1 answer
Mysql extract day from date leading zero
SQL