GETDATETIME

Syntax

GETDATETIME ( )

Description

Returns the current time of the computer where the Connect on-premise agent is installed. or current UTC date and time when a Connect cloud agent is used.

Returns

The current time as determined by the time zone of the computer where the Connect on-premise agent is installed. If a Connect cloud agent is used, this function returns UTC date and time. Connect cloud agent results are the same as the results returned by the GETUTCDATETIME function.

Remarks

Use GETDATETIME( ) as a link to a CreatedDate or ModifiedDate field, which populates the field with the current date and time that this record was inserted or updated.

Example

GETDATETIME()

Returns: Date and time in yyyy-mm-dd hh:mm:ss:mmm format, such as