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 vote203 views1 answer
Mysql, how to query the table comments?
SQL
4 votes223 views3 answers
Sqlite show columns
SQL
0 vote192 views1 answer
How many columns can be used for creating index?
SQL
8 votes223 views1 answer
Mysql restore database
SQL
0 vote198 views1 answer
Sql where part of string match
SQL
0 vote192 views1 answer
Sql how to display two atributes as one in sql
SQL
-1 vote256 views1 answer
MYSQL stored procedure select from
SQL
12 votes189 views3 answers
Duplicate a column in sql
SQL
4 votes215 views1 answer
Mysql ip address data type
SQL
10 votes208 views3 answers
How to fetch first 5 characters in sql
SQL