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 vote201 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
2 votes176 views3 answers
Current month mysql query
SQL
2 votes175 views1 answer
SELECT INTO
SQL
3 votes169 views1 answer
Mysql load sql from file
SQL
16 votes187 views5 answers
Select last row in sql
SQL
0 vote174 views1 answer
Oracle list datafiles
SQL
16 votes203 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote166 views1 answer
Sql auto date
SQL
0 vote154 views1 answer
Get all employees if name ends with in sql
SQL
0 vote221 views2 answers
Insert data into multiple tables mysql
SQL