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

5 votes347 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote403 views1 answer
Mysql sum per week
SQL
2 votes347 views1 answer
How to get weekday from old date in sql
SQL
1 vote366 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote356 views1 answer
Const pool = mysql.createpool()
SQL
3 votes339 views5 answers
Mysql get last inserted id
SQL
2 votes359 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes390 views3 answers
Postgres json to string
SQL
1 vote376 views1 answer
Sql headers delphi
SQL
1 vote337 views1 answer
How to select department from table
SQL