- biGENIUS-X Knowledge Base
- Generators
- Default Terms
-
Getting Started
-
General Overview
-
Application Modules
- Administration
- Global Features
- Solutions
- Projects
- Branches
- Source Systems
- Dataflow Modeling - Overview
- Dataflow Modeling - Wizard Steps
- Dataflow Modeling - Terms
- Dataflow Modeling - Term Mapping
- Dataflow Modeling - Relationships
- Relationship Modeling
- Generate Artifacts
- Project Settings
- Data Marketplace
-
Generators
-
Discovery application
-
Best Practices
-
FAQs
-
Product Release Notes
-
Legal Documents
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: