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 vote272 views1 answer
Mysql error codeigniter
SQL
1 vote317 views1 answer
Encrypt password postgresql
SQL
10 votes294 views1 answer
Oracle dependencies table
SQL
6 votes282 views1 answer
Check Table Exists
SQL
-1 vote339 views4 answers
Full outer join in sql
SQL
0 vote274 views1 answer
Mysql docker image for macbook m1
SQL
0 vote307 views1 answer
Wp_query raw sql
SQL
0 vote304 views1 answer
R write csv without index
SQL
0 vote321 views1 answer
How to fetch data from database in sql
SQL
2 votes294 views2 answers
Run mysql command from bash
SQL