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

-2 votes264 views1 answer
Use of where in left join in mysql
SQL
4 votes294 views1 answer
Sql delete multiple conditions
SQL
4 votes263 views2 answers
Sql table
SQL
0 vote249 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote261 views1 answer
Sql database connectivity
SQL
0 vote282 views1 answer
Java nosql sort
SQL
3 votes303 views2 answers
Synonym oracle
SQL
0 vote248 views1 answer
Access refused mysql xampp server
SQL
13 votes271 views2 answers
Get tables in database sql
SQL
0 vote270 views1 answer
Sql composite key
SQL