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