To store date values. When defining a Date data type, it is not necessary to specify other properties. The user must specify the associated picture.
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)
Examples
&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
|