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 vote192 views1 answer
Display first three characters sql
SQL
42 votes259 views6 answers
Sql query duplicate rows
SQL
0 vote186 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote183 views1 answer
Jenkins SQLCMD run
SQL
0 vote218 views1 answer
Sql server delete records with specific date
SQL
0 vote213 views1 answer
How much space does sql server take per row
SQL
0 vote281 views3 answers
Fetlife
SQL
3 votes201 views2 answers
Sqlite print all column names
SQL
0 vote192 views1 answer
What does leave do in mysql
SQL
0 vote186 views1 answer
Mssql now diff 90 day
SQL