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

2 votes205 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote184 views1 answer
Mysql read row
SQL
0 vote220 views1 answer
Capabilities of sql select statements
SQL
0 vote175 views1 answer
Mysql shell set time_zone
SQL
0 vote201 views1 answer
T sql dynamic top n query
SQL
9 votes184 views4 answers
Oracle get table column names
SQL
18 votes179 views6 answers
Drop table if exists
SQL
0 vote193 views1 answer
Express api ith mysql data
SQL
4 votes169 views2 answers
Select first and last row mysql
SQL
3 votes181 views3 answers
Django.db.utils.OperationalError: no such table:
SQL