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

2 votes361 views2 answers
Mysql count rows returned
SQL
0 vote347 views2 answers
Py sqlite if entry exists
SQL
0 vote309 views1 answer
Hallo
SQL
0 vote342 views1 answer
Mysql c commands
SQL
0 vote335 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote435 views1 answer
Restart serial number for postgres
SQL
0 vote316 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote327 views1 answer
How to get table current identity value in sql server
SQL
0 vote333 views1 answer
Mysql workbench indent formatting
SQL
0 vote349 views1 answer
Hibernate show sql xml property
SQL