Conversion to date functions
We outline next all the conversion forms to date data type (we only specify the MS-SQL Server version of the interpretation of the functions):
|
Option name in the popup list |
Inserted string (where Fld is the selected field) |
|
Date-Time |
CAST(Fld AS DATETIME) |
|
Small Date-Time |
CAST(Fld AS SMALLDATETIME) |
|
Time-Stamp |
CAST(Fld AS TIMESTAMP) |