Overview
Syntax | NOW() | Gets the current time. |
Notes
No parameter is required in the function.
Example
If you only need to obtain the year, month, and day of the current time, you can use the nested formula FORMAT(LEFT(NOW(),10),"yyyy-MM-dd"), as shown in the following figure.
The following table describes more examples.
Formula | Result | Note |
NOW() | 2012-05-12 15:18:38 | Gets the result if the system time is May 12, 2012, 15:18:38. |
