|
|
|
|
cdbIntegerToDateTime (Function) In french: cdbEntierVersDateHeure Transforms the value of a Date and Time column (unsigned 8-byte integer) into a DateTime variable.
// Find out the registration date found in column 2 ResDate = cdbCol("MyDatabase", "Customer", 2) // Convert the date RegistrationDate is DateTime = cdbIntegerToDateTime(ResDate) // Format the date RegistrationDate = DateToString(RegistrationDate) // Display the registration date Info("The registration date is: " + RegistrationDate)
Syntax
<Result> = cdbIntegerToDateTime(<Value to convert>)
<Result>: DateTime DateTime value. <Value to convert>: Unsigned 8-byte integer Value that must be converted into DateTime. This value is compatible with a Date and Time column (unsigned 8-byte integer). This value corresponds to the number of tenths of microsecond since January 1, 1601. Remarks This conversion triggers a loss of precision: the DateTime format does not keep the tenth of microseconds. Caution: cdbIntegerToDateTime returns no error code. To find out whether an error was generated by this function, use the ErrorOccurred variable.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|