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 vote219 views1 answer
Oracle turn off constraint
SQL
1 vote223 views5 answers
What is in operator in sql
SQL
8 votes190 views5 answers
Grant permission in postgres
SQL
0 vote209 views1 answer
Components/Fields of Internal Table
SQL
3 votes340 views1 answer
Sql add two values together
SQL
-3 votes196 views1 answer
Remove spaces sql 2008
SQL
0 vote205 views1 answer
Open postgresql.conf in centos
SQL
0 vote207 views1 answer
Mysql terminal run sql file
SQL
0 vote176 views1 answer
Sql table to store status
SQL
2 votes262 views2 answers
Postgres set user as superuser
SQL