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 vote162 views1 answer
T-sql delete view if exists
SQL
0 vote113 views1 answer
Mysql command line ubuntu
SQL
0 vote143 views1 answer
Oracle create package specification
SQL
0 vote116 views1 answer
Mysql find db contarint
SQL
0 vote72 views1 answer
Mssql view column data type
SQL
0 vote114 views1 answer
Consecutive numbers sql
SQL
1 vote104 views2 answers
T sql get foreign key
SQL
0 vote120 views1 answer
Incorrect string value: mysql
SQL
3 votes153 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
-1 vote138 views4 answers
Postgres between dates
SQL