NOW()

Scalar. Returns a timestamp corresponding to the current time. Note that this function is lower resolution than Highresolutionnow(), but users considerable fewer resources. Use this version when performance is a higher priority than resolution.

Syntax

NOW()

Data Types
Return
Timestamp

Example

The following example returns the current time minus the row timestamp:

INSERT INTO OutStream
SELECT NOW() - GETTIMESTAMP(Devices)
FROM Devices;