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 vote183 views1 answer
Como leer datos de mysql esp32
SQL
0 vote225 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
3 votes180 views4 answers
Show columns from table
SQL
4 votes238 views1 answer
Postgres delete last row
SQL
1 vote212 views1 answer
Sql select all from one table and one column from another
SQL
0 vote226 views1 answer
T sql dynamic top n query
SQL
62 votes225 views8 answers
Mysql add column
SQL
0 vote207 views1 answer
To change the database owner in SQL server
SQL
1 vote240 views1 answer
Create email address from first and last name in sql
SQL
7 votes215 views1 answer
Oracle pagination query rownum
SQL