Skip to Content

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.

Syntax

NOW(<origin>)

Parameters

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

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).

Examples

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

Local (default)

NOW()

Returns 2024-08-01 17:00:34.873

Local

NOW(LOCAL)

Returns 2024-08-01 17:00:34.873

Utc

NOW(UTC)

Returns 2024-08-01 21:00:34.873