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 vote192 views1 answer
Mysql sum per week
SQL
18 votes158 views6 answers
Create table mysql
SQL
8 votes151 views2 answers
Phpmyadmin default password
SQL
0 vote161 views1 answer
SqlFunction does not exist
SQL
0 vote158 views1 answer
Oracle create job if not exists
SQL
58 votes461 views6 answers
Create new user in postgres
SQL
0 vote148 views1 answer
Backup a table in sql
SQL
0 vote148 views1 answer
Sql compound operators
SQL
1 vote159 views1 answer
Mysql show queries running
SQL
0 vote144 views1 answer
Check if a word appears at the end sql query
SQL