|
|
|
|
|
|
|
|
cdbDateTimeToInteger (Function) In french: cdbDateHeureVersEntier Transforms a DateTime variable into a value compatible with a Date and Time column (unsigned 8-byte integer).
// Add a record into Customer file
cdbWriteCol("MyDatabase", "Customer", "LastName", "Smith")
cdbWriteCol("MyDatabase", "Customer", "FirstName", "Paul")
cdbWriteCol("MyDatabase", "Customer", "City", "Avignon")
RegistrationDate is DateTime = "200112311524"
// Transform this variable
cdbWriteCol("MyDatabase", "Customer", "Registration", cdbDateTimeToInteger(RegistrationDate))
cdbAdd("MyDatabase", "Customer")
Syntax
<Result> = cdbDateTimeToInteger(<Value to convert>)
<Result>: Unsigned 8-byte integer Value 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. <Value to convert>: DateTime Value to convert into a compatible value. Remarks Caution: cdbDateTimeToInteger 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|