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 vote163 views1 answer
How convert into in in sql query
SQL
13 votes160 views1 answer
Sql join 3 tables on id
SQL
0 vote159 views1 answer
Redshift running queries
SQL
0 vote160 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote137 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote145 views1 answer
Python mysql query to dataframe
SQL
0 vote142 views1 answer
Left join in codeigniter query builder
SQL
2 votes140 views1 answer
Pandas to sql index
SQL
0 vote156 views1 answer
Select odd records sql
SQL
1 vote144 views1 answer
Oracle difference between two dates in years
SQL