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 vote100 views1 answer
Mysql timediff
SQL
0 vote104 views1 answer
Oracle archivelog usage
SQL
1 vote99 views2 answers
Grab part of a string sql
SQL
0 vote152 views1 answer
Delete from IN subquery
SQL
0 vote109 views1 answer
Select place default lat long
SQL
0 vote97 views1 answer
Postgresql isnull with max
SQL
8 votes116 views3 answers
SQL column name
SQL
0 vote97 views1 answer
Pgadmin see indexes
SQL
0 vote111 views1 answer
Postgresql check total storage
SQL
0 vote105 views1 answer
Create table as select sql server error
SQL