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 vote156 views1 answer
Postrgres trunc
SQL
10 votes156 views3 answers
Sql limit results
SQL
0 vote217 views1 answer
Soql last week
SQL
2 votes169 views6 answers
In in sql
SQL
0 vote164 views1 answer
Show create table in postgresql
SQL
0 vote121 views1 answer
How to set field to null in sql
SQL
0 vote192 views1 answer
Select all same column value in sql
SQL
65 votes527 views6 answers
Sql add column to table
SQL
0 vote166 views1 answer
Ffeathers express mysql application users login
SQL
-1 vote166 views1 answer
Mysql #1064 error
SQL