# 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_TIMESTAMP()`**: 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()`**  
```
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.