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

1 vote306 views1 answer
Mysql dump specific tables
SQL
0 vote313 views1 answer
Delete data from database sqlite android
SQL
0 vote318 views1 answer
Oracle select partition
SQL
1 vote325 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote322 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote348 views2 answers
Check if sql temp table exists
SQL
1 vote283 views1 answer
Autocommit mysql
SQL
0 vote310 views1 answer
Sql check for null and empty string
SQL
48 votes357 views3 answers
Psql create database
SQL
0 vote295 views1 answer
Postgresql isnull with max
SQL