Default Terms
      Back to home
      1. biGENIUS-X Knowledge Base
      2. Generators
      3. 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: