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 vote68 views1 answer
Mysql insert with foreign key
SQL
0 vote152 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote130 views1 answer
How to change mysql port in xampp
SQL
3 votes110 views1 answer
Sql server version query
SQL
0 vote99 views1 answer
Remove binlog mysql
SQL
1 vote59 views1 answer
Postgres reset auto increment
SQL
0 vote113 views1 answer
SQL Server Enterprise
SQL
0 vote100 views1 answer
Increment id in mysql
SQL
2 votes104 views1 answer
Postgresql add entry to table
SQL
0 vote109 views1 answer
Sort by last two number sql
SQL