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 vote189 views1 answer
Oracle enable job
SQL
1 vote222 views2 answers
Changes not showing on website server odoo
SQL
0 vote206 views1 answer
Sort by
SQL
0 vote210 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote192 views1 answer
Postgres reorder columns
SQL
1 vote147 views1 answer
Psql kill pid
SQL
1 vote189 views1 answer
Age postgres
SQL
0 vote197 views1 answer
Mysql random number between 1 and 100
SQL
10 votes270 views4 answers
Sql server pagination
SQL
23 votes194 views6 answers
Create table sql server
SQL