Now() mvSQL database function in Jitterbit App Builder

Summary

Gets the current date and time without a time zone offset.

Note

See the Time zones article for more information.

NOW(<origin>)

The logical time zone. Supported values include:

LOCAL - Data provider local time. In the case of an RDBMS, typically the database server local time.
UTC - Coordinated Universal Time.

Optional. Defaults to LOCAL.

Returns a datetime.

The datetime data type stores a timestamp without a time zone offset.

If the data source has a Time Zone value configured, App Builder will return the same value for both Now(LOCAL) and Now(UTC).

The following examples assume that the current date and time in UTC is 2024-08-01 21:00:34.873.

NOW()

Returns 2024-08-01 17:00:34.873

NOW(LOCAL)

Returns 2024-08-01 17:00:34.873

NOW(UTC)

Returns 2024-08-01 21:00:34.873