Stores Date values.
The following table illustrates the conversion done by GeneXus according to the DBMS:
DBMS |
Conversion |
Oracle |
DATE |
DB2 Universal Database |
DATE |
Informix |
DATE |
SQL Server |
DATETIME |
Access |
DBDate |
DB2 for iSeries |
CHAR(8) or DATE1 |
DBF |
DATE(8,0) |
PostgreSQL |
DATE |
1 Depends on the Date data type definition environment Property.
The following link illustrates the pictures that can be applied to Date data types: Picture Properties Group
Static methods
Date.New(Year,Month,Day)
Sample
&ExpirationDate = Date.New(2018,6,10)
If &ExpirationDate >= Date.New(2018,6,10)
msg("The date has expired")
EndIf
DateTime data type
Data types list