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

6 votes290 views2 answers
Mysql timestamp to date
SQL
0 vote267 views1 answer
Dapper run sql script with parameters
SQL
0 vote263 views1 answer
Get time component of datetime sql
SQL
0 vote288 views1 answer
SQL FROM-Klausel
SQL
2 votes460 views5 answers
Unique in sql server
SQL
0 vote265 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
16 votes289 views1 answer
Mysql reset auto increment value
SQL
14 votes305 views3 answers
How to add default constraint in mysql
SQL
1 vote256 views1 answer
How to give access to database in postgresql server to another user
SQL
3 votes283 views1 answer
Laravel database Using Named Bindings
SQL