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 vote139 views1 answer
Where case insensitive like mysql
SQL
1 vote156 views1 answer
Oracle grant on all tables in schema
SQL
1 vote143 views1 answer
Sql select all from one table and one column from another
SQL
4 votes232 views1 answer
Mysql store ip address
SQL
2 votes195 views1 answer
Username sql
SQL
10 votes160 views3 answers
How to fetch first 5 characters in sql
SQL
6 votes202 views2 answers
How to get last element sql
SQL
0 vote164 views1 answer
Two inner joins sql
SQL
0 vote141 views1 answer
Call scalar valued function sql
SQL
0 vote154 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL