PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Various
  • Managing errors
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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.
Components
WINDEVReports and QueriesWindows Mobile wd230ce.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment