SYSDATE()

Function description

The SYSDATE() function returns the value in the 'YYY-MM-DD HH:MM:SS' format of the current date and time.

SYSDATE() returns the dynamic real-time time during execution. This is different from the behavior of NOW(), which returns the time when the statement starts to execute.

Function Syntax

> SYSDATE(fsp)

Parameter definition

Parameters	Description
fsp	Non-essential parameters. If the fsp parameter is given to specify a fractional second accuracy from 0 to 6, the return value includes the fractional second portion of the number.

Example

mysql> select sysdate();
+----------------------------------+
| sysdate() |
+----------------------------------+
| 2024-04-30 10:49:39.554807 |
+----------------------------------+
1 row in set (0.00 sec)

mysql> select sysdate(6);
+----------------------------------+
| sysdate(6) |
+----------------------------------+
| 2024-04-30 10:50:08.452370 |
+----------------------------------+
1 row in set (0.00 sec)

mysql> SELECT SYSDATE(), SLEEP(2), SYSDATE();
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| sysdate() | sleep(2) | sysdate() |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 2024-04-30 10:50:30.004912 | 0 | 2024-04-30 10:50:32.005203 |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (2.00 sec)

mysql> SELECT NOW(), SLEEP(2), NOW();
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| now() | sleep(2) | now() |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 2024-04-30 10:50:47.904309 | 0 | 2024-04-30 10:50:47.904309 |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (2.00 sec)