cdbIntegerToDateTime (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Various
Managing errors

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

cdbIntegerToDateTime (Function)

In french: cdbEntierVersDateHeure

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

Example

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

Various

This conversion triggers a loss of precision: the DateTime format does not keep the tenth of microseconds.

Managing errors

Caution: cdbIntegerToDateTime returns no error code. To find out whether an error was generated by this function, use the ErrorOccurred variable.

Component: wd260ce.dll