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).
Example
MyDay is DateTime
MyDay = "20170726100941"
// Displays "1501056581" (in France)
Info(MyDay.ToEpoch())
Syntax
<Result> = <Data to convert>.ToEpoch([<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>: DateTime variable
DateTime variable corresponding to the local date and time to convert. 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.
Remark: 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 / UI classification : Neutral code
Component : wd250std.dll
Minimum version required
  • Version 24
This page is also available for…
Comments
Click [Add] to post a comment