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

9 votes199 views3 answers
Import DB through mysql console
SQL
0 vote174 views1 answer
Ms Sql set us timezone
SQL
0 vote183 views1 answer
Recursive query herarchical data sql server
SQL
1 vote219 views1 answer
Liquibase alter column type / length
SQL
5 votes190 views1 answer
Sql check if date is between 2 dates
SQL
0 vote185 views1 answer
Datagrip exec
SQL
9 votes224 views3 answers
Sql delete where in
SQL
0 vote206 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote199 views1 answer
Mysql 8 geo to json
SQL
0 vote187 views1 answer
Mssql describe stored procedure sqlcmd
SQL