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

1 vote151 views3 answers
Sql union
SQL
0 vote166 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote162 views1 answer
Sql #region
SQL
4 votes177 views1 answer
Ms sql truncate table vs delete
SQL
0 vote145 views1 answer
How to use sqlcommand
SQL
27 votes151 views4 answers
Get all tables with column name sql
SQL
0 vote149 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote139 views1 answer
Oracle index hint multiple tables example
SQL
0 vote132 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote156 views1 answer
Oracle list partitions
SQL