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 votes348 views1 answer
Mysql set field unique
SQL
0 vote495 views1 answer
Sql insert exemplo
SQL
0 vote346 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
17 votes326 views5 answers
Order by sql
SQL
-1 vote353 views1 answer
Get id from just inserted row mysql server python
SQL
1 vote345 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote328 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote368 views2 answers
Pop sql insert value into
SQL
0 vote411 views1 answer
Sql query for login with email or username
SQL
0 vote333 views1 answer
Call function in query sql server
SQL