SYSDATE

Declaration

SYSDATE(fsp)

Description

Returns the current date and time in the format %Y-%m-%d %H.%i.%s.

fsp specifies the number of digits in the fractional seconds part of the return value. Valid values are integers from 0 to 6, with a default value of 0.

Examples

SELECT SYSDATE();
+---------------------+
| SYSDATE()           |
+---------------------+
| 2025-12-17 17:45:07 |
+---------------------+
1 row in set (0.001 sec)