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

2 votes369 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote367 views1 answer
Mysql isshow
SQL
0 vote378 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
5 votes417 views1 answer
Mysql count lines
SQL
1 vote363 views1 answer
Sysdate in sql
SQL
1 vote345 views1 answer
Sql injection
SQL
0 vote418 views1 answer
Eliminate zero from integer mysql
SQL
0 vote351 views1 answer
List mysql tables and views
SQL
0 vote353 views1 answer
Renommer schema sql
SQL
5 votes369 views1 answer
Minecraft java port number
SQL