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