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

16 votes177 views4 answers
Find duplicates mysql
SQL
50 votes238 views6 answers
Sql count duplicate rows
SQL
1 vote148 views1 answer
Sql count value greater than
SQL
0 vote142 views1 answer
How to put value in parameters in mysqldataadapter
SQL
5 votes148 views3 answers
MySql get fields of table
SQL
6 votes170 views2 answers
Oracle compile trigger
SQL
0 vote180 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote93 views1 answer
Kannst du deine finger trainieren
SQL
0 vote162 views1 answer
Oracle current date minus 1 day
SQL
36 votes135 views3 answers
Finding duplicate column values in table with sql
SQL