Stores Date values.
The following table illustrates the conversion GeneXus performs 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.
Read about Pictures that can be applied to Date data types.
Static methods
Date.New(Year,Month,Day)
&ExpirationDate = Date.New(2018,6,10)
If &ExpirationDate >= Date.New(2022,1,4)
msg("The date has expired")
EndIf
When generating iOS code, controls based on Date / DateTime data type, use the Date format property and Hour format property to infer the native styles dateStyle and timeStyle which take into account the user's preferences in the device settings.
DateTime data type
Data types list