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) |