# Date And Time Function
__*NOW function*__
__*CURDATE function*__
__*CURTIME function*__
__*YEAR function*__
__*MONTHNAME function*__
__*DAYNAME function*__
__*DAYOFYEAR function*__
__*HOUR function*__
__*MINUTE function*__
__*SECOND function*__
__*MICROSECOND function*__
+ `NOW()`: The current date time on the server, return DATETIME, length of fractional seconds parts can be specified
+ `CURDATE()`: The current date on the server, return DATE
+ `CURTIME()`: Time on the current server, return TIME, length of fractional seconds parts can be specified
+ `CURRENT_TIMESTMAP()`: Timestamp on the current server, return TIMESTAMP, length of fractional seconds parts can be specified
+ `YEAR()`: The YEAR format
+ `MONTHNAME()`: Month of the year
+ `DAYNAME()`: Day of the week
+ `DAYOFYEAR()`: Day of the year
+ `HOUR(), MINUTE(), SECOND(), MICROSECOND()`  
```9







tidb> SELECT now(), curdate(), curtime(), year(now()), dayname(now());
+---------------------+------------+-----------+-------------+----------------+
| now()               | curdate()  | curtime() | year(now()) | dayname(now()) |
+---------------------+------------+-----------+-------------+----------------+
| 2022-01-06 10:09:10 | 2022-01-06 | 10:09:10  |        2022 | Thursday       |
+---------------------+------------+-----------+-------------+----------------+
```

------------------------------------------------------------

NOW(), CURTIME() and CURRENT_TIMESTAMP() accept an integer to specify the fractional seconds part length.