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 votes141 views2 answers
Postgresql select all column names
SQL
57 votes301 views6 answers
Mysql alter table add column
SQL
1 vote125 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote125 views1 answer
Postgre admin slow
SQL
10 votes133 views3 answers
Insert into auto increment mysql
SQL
0 vote130 views2 answers
Database owner can't create new tables postgres
SQL
2 votes126 views1 answer
Sql find missing values between two tables
SQL
0 vote145 views1 answer
To_date sql
SQL
0 vote167 views2 answers
How to prevent sql injection in java
SQL
0 vote158 views1 answer
000webhost database values insert
SQL