cdbDateTimeToInteger (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

cdbDateTimeToInteger (Function)

In french: cdbDateHeureVersEntier

Transforms a DateTime variable into a value compatible with a Date and Time column (unsigned 8-byte integer).

Example

// 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.

Component: wd260ce.dll