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

7 votes121 views4 answers
Lowest salary in sql
SQL
0 vote166 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
2 votes128 views2 answers
Set database timezone mysql
SQL
0 vote125 views1 answer
Addition of 2 column value in mysql
SQL
2 votes132 views2 answers
Postgresql search all tables for column name
SQL
4 votes171 views1 answer
Sql select limit range
SQL
6 votes131 views5 answers
Sql add months to date
SQL
1 vote137 views1 answer
Postgresql update auto_increment value
SQL
2 votes87 views5 answers
Alter table primary key postgresql
SQL
0 vote144 views1 answer
Python sqlalchemy connection show server
SQL