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 vote299 views1 answer
Mysql with
SQL
1 vote338 views1 answer
Sql select max value from multiple rows
SQL
0 vote367 views1 answer
Mysql where sum > 0
SQL
0 vote340 views2 answers
Uninstall postgresql mac
SQL
1 vote309 views1 answer
Temp table vs variable table in sql server
SQL
12 votes328 views4 answers
Mysql ifnull
SQL
0 vote324 views1 answer
Postgresql default value boolean
SQL
0 vote335 views1 answer
How to insert a uniqueidentifier in sql
SQL
8 votes340 views1 answer
Check mysql version phpmyadmin
SQL
0 vote307 views1 answer
Minecraft duping allowed servers
SQL