Returns the current system time in the UTC+8 time zone.
Syntax
datetime getdate()Return value
Returns the current date and time as a DATETIME value.
Note
In MaxCompute SQL, GETDATE always returns a fixed value. By default, the time is accurate to the second. If the MaxCompute V2.0 data type edition is enabled, accuracy increases to the millisecond.
Precision
| Condition | Precision | Example output |
|---|---|---|
| Default | Second | 2026-03-26 10:30:45 |
| MaxCompute V2.0 data type edition enabled | Millisecond | 2026-03-26 10:30:45.123 |
Related functions
GETDATE is a date function. For the full list of date and time functions in MaxCompute SQL, see Date functions.