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 vote142 views1 answer
Less mysql display
SQL
1 vote125 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote131 views1 answer
Postgres regex word boundary
SQL
0 vote127 views1 answer
Use where instead of join
SQL
8 votes127 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote129 views1 answer
Postpresql relation not found
SQL
0 vote146 views1 answer
Sub query in linq
SQL
0 vote121 views1 answer
Change database name psql 8
SQL
0 vote128 views1 answer
Postgre admin slow
SQL
0 vote133 views1 answer
Oracle call a function in a insert statement
SQL