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 votes211 views1 answer
Mysql sysdate
SQL
0 vote219 views1 answer
Inserted row count tsql
SQL
0 vote227 views3 answers
Run sql command line
SQL
6 votes212 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote203 views1 answer
How to count null values in sql
SQL
0 vote215 views1 answer
Mysql show category once count how many products
SQL
0 vote266 views1 answer
How to use sqlcommand
SQL
0 vote211 views1 answer
Power bi dax add related shows column but not working
SQL
3 votes216 views1 answer
Uppercase and lowercase in sql
SQL
1 vote210 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL