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 vote98 views1 answer
Get all employees if name ends with in sql
SQL
-1 vote127 views1 answer
Create view in mysql workbench
SQL
0 vote110 views1 answer
Testing sql queries
SQL
0 vote97 views1 answer
Pl sql constraint user function
SQL
0 vote99 views1 answer
Consecutive numbers sql
SQL
0 vote102 views1 answer
Show function mysql
SQL
0 vote94 views3 answers
Remove folders from remote git
SQL
18 votes118 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
1 vote95 views1 answer
Adding a default constraint to an existing column in sql
SQL
14 votes97 views3 answers
Sql trim from string
SQL