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

3 votes183 views2 answers
Postgres download
SQL
1 vote180 views1 answer
Media sql
SQL
0 vote194 views1 answer
Oracle get running queries
SQL
0 vote246 views3 answers
Mysql keyword search
SQL
20 votes184 views2 answers
Counting in sql
SQL
1 vote208 views1 answer
Sqlite update from another table
SQL
0 vote204 views1 answer
Window function to forward fill
SQL
0 vote193 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
1 vote255 views1 answer
How to show index type in postgresql
SQL
4 votes194 views1 answer
Group by mysql and concatenate string
SQL