- biGENIUS-X Knowledge Base
- Generators
- Default Terms
BG_ValidToTimestamp
Description
The Default Term named BG_ValidToTimestamp contains the end date of the validity of the row.
Format
The BG_ValidToTimestamp is a datetimeoffset(7).
Value
It contains:
- For a new row: NULL
- For an existing row with an incremental load: the current date and the time with the time zone.
Calculation:
SELECT SYSDATETIMEOFFSET() as CurrentDateTimeWithTimeZone
Example of value in the CET time zone with UTC+2:
