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

3 votes338 views2 answers
How to start mysql in terminal
SQL
0 vote332 views1 answer
Insert output identity
SQL
8 votes354 views4 answers
Reset SQL auto increment
SQL
1 vote347 views1 answer
Oracle datafile max size 32gb
SQL
10 votes325 views2 answers
Sql rtrim
SQL
0 vote345 views1 answer
Sql if clause within where clause
SQL
0 vote325 views1 answer
Default value false mysql
SQL
1 vote271 views1 answer
Oracle compile schema
SQL
60 votes548 views6 answers
Add column in sql
SQL
3 votes354 views1 answer
Sql case update
SQL