Advantage Expression Engine function that returns the current system date and time as a timestamp value

Syntax

NOW() -> Timestamp

Return Values

NOW() returns the system date and time as a timestamp value.

Remarks

NOW() is a datetime function that provides a means of initializing memory variables to the current Timestamp and comparing other Timestamp values to the current Timestamp.

Note Advantage Expression Engine functions can be used in expressions such as record filter expressions and index expressions. They are not necessarily scalars supported within SQL statements. For a list of supported SQL scalar functions, see Supported Scalar Functions.

See Also

TODAY()

TIME()

STOTS()