Page History
...
From: | Character | Unicode Character | Numeric | Date/Time | Binary | LOB 4 | Boolean |
|---|---|---|---|---|---|---|---|
Character | Yes | Yes 5 | Yes 1 | Yes 1 | Yes | Yes | Yes |
Unicode Character | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Numeric | Yes | Yes | Yes | Yes 2 | No | No | Yes |
Date/Time | Yes | Yes | Yes 2 | Yes 3 | No | No | No |
Binary | Yes | Yes | No | No | Yes | No | No |
LOB 4 | Yes | Yes 5 | No | No | Yes | Yes | No |
Boolean | Yes | Yes | Yes | No | No | No | Yes |
Table notes:
- CLOBs are treated as file pointers, so do not support conversion to a Numeric or Date/Time field type.
- No support for conversion
- between Integer or Float and the Date/Time field types
- of a numeric type directly to a DateTime, as there is no way to determine if the type should be setting the Date or Time portion of the DateTime.
- DateTime -> Date and DateTime -> Time are obvious.
The default Date is 1900-01-01 and the default time is midnight (00:00:00). Therefore:- Date -> DateTime sets the time part to midnight
- Time -> DateTime sets the date part to 1900-01-01
- Date -> Time always results in midnight
- Time -> Date always results in 1900-01-01
- The "value" for a LOB is a filename. Thus, when converting it is the filenames that are being copied, not the data. If an invalid filename is copied to a LOB, an error will occur at some stage.
- When converting a Unicode string to a native string, the intrinsic AsNativeString may need to be used.