- biGENIUS-X Knowledge Base
- Generators
- Default Terms
BG_Effectivity_End
Description
The Default Term named BG_Effectivity_End contains the end date of the effectivity of the row.
Format
The BG_Effectivity_End is a datetimeoffset(7).
Value
It includes 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: