CToT Function |  |
-- todo --
Returns a DateTime value from a character expression.
Namespace: XSharp.VFP
Assembly: XSharp.VFP (in XSharp.VFP.dll) Version: 2.21
SyntaxRequest Example
View Source
DateTime data type. CToT( ) returns a DateTime value from a character expression.
Parameters
- cCharacterExpression (Optional)
- Type: Usual
Specifies the character expression from which a DateTime value is returned.
Return Value
Type: UsualDateTime data type. CToT( ) returns a DateTime value from a character expression.
Remarks Note |
|---|
| CToT() can create ambiguous DateTime values and generates a compilation error when Set STRICTDATE is set to 2. To create nonambiguous Date values, use the DATETIME( ) function instead. |
| Note |
|---|
| The CToT() function does not address the 19 different ways that T-SQL Convert() function returns datetime and smalldatetime values. |
| Note |
|---|
| CToT( ) resolves these dates to the limits of precision of the X# DateTime data type. Therefore, precision can be lost when using CToT( ) with certain formats. The X# DateTime data type does not support milliseconds or time zones. |
The following examples show how CToT( ) handles DateTime values from different sources. In all examples, CToT( ) converts the DateTime values correctly without needing to call Set DATE YMD. Access 2000 XML date format
X#
1* 2000-10-24T13:30:00 (24-hour format is exported from Access, 2* whether original was in 12- or 24-hour format) 3? CToT("2000-10-24T13:30:00")
X#
1? CToT("2000-10-24T20:47:58.170") // datetime (24-hour format) 2? CToT("2000-10-24T21:11:00") // Small DT (24-hour format) 3? CToT("2000-10-03T02:02:02")
X#
1? CToT("2002-10-05T04:04:04.0000000-07:00")
X#
1? CToT("2001-09-14T07:00:00Z")
See Also