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 vote203 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote275 views1 answer
Restart serial number for postgres
SQL
7 votes197 views1 answer
Sql server convert string to date
SQL
-1 vote231 views3 answers
Compute age mysql
SQL
0 vote217 views1 answer
Alter table change default
SQL
12 votes197 views4 answers
Mysql ifnull
SQL
1 vote211 views1 answer
How to print longest name in sql
SQL
8 votes207 views1 answer
How to check mysql version in xampp
SQL
4 votes268 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote212 views1 answer
Create table with float datatype in sql server
SQL