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

18 votes272 views3 answers
Get the list of all tables in sql server
SQL
3 votes260 views3 answers
Sql last week
SQL
0 vote266 views1 answer
Postgresql linux password
SQL
0 vote250 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote258 views1 answer
Template MySQL Zabbix agent
SQL
1 vote256 views1 answer
Postgres check for foreign key
SQL
0 vote252 views1 answer
How to open mysql in docker
SQL
0 vote246 views1 answer
Order by number of character in sql
SQL
22 votes250 views3 answers
Sql cheat sheet
SQL
1 vote249 views1 answer
Sql select contem uma palavra
SQL