PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
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
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.
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