PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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
Converts a local date-time to the Epoch format (number of time units from 01/01/1970 at 00h00 UTC).
Versions 24 and later
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
New in version 24
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for Android applications.
Example
// Displays "1501056581" (in France)
Info(DateTimeToEpoch("20170726100941"))
MyDay is DateTime
MyDay = "20170726100941"
// Displays "1501056581" (in France)
Info(DateTimeToEpoch(MyDay))
Syntax
<Result> = DateTimeToEpoch(<Data to convert> [, <Conversion options>])
<Result>: 8-byte integer
  • Date and time in Epoch format (number of time units since 01/01/1970 at 00h00 UTC).
  • -1 if an error occurred (invalid date and time).
<Data to convert>: Character string (with quotes)
Local date and time to convert. Can correspond to:
  • a DateTime variable.
  • a character string with one of the following formats:
    • YYYYMMDDHHMMSSLLL
    • YYYYMMDDHHMMSSCC
    • YYYYMMDDHHMMSS
    • YYYYMMDDHHMM
    • YYYYMMDDHH
    • YYYYMMDD
This parameter will be considered as being invalid in the following cases:
  • if the date is invalid or if it is earlier than 01/01/1970. The date validity can be checked by DateValid.
  • if the time is invalid. The time validity can be checked by TimeValid.
Note: You have the ability to use dates beyond year 2038.
<Conversion options>: Optional Integer constant
Options for converting the date and time to Epoch format:
epochUnixMillisecondThe result will be expressed in milliseconds from 01/01/1970 at 00h00 UTC (time 0 in Unix).
epochUnixSecond
(default value)
The result will be expressed in seconds from 01/01/1970 at 00h00 UTC (time 0 in Unix).
Business / GUI classification : Neutral code
Component : wd250std.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment