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

5 votes325 views5 answers
Find max number in sql
SQL
0 vote319 views1 answer
Initcap in mysql
SQL
0 vote312 views1 answer
Sql server isnull function nor working count
SQL
13 votes288 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote315 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote409 views1 answer
Reset a table's identity column and remove test records
SQL
2 votes308 views1 answer
Oracle number to percentage
SQL
0 vote319 views1 answer
Postgresql function ROUND
SQL
3 votes345 views2 answers
Oracle sql first day of month
SQL
0 vote331 views1 answer
Insert set mysql
SQL