DateTime2Clock
- Last UpdatedOct 29, 2026
- 2 minute read
This function calculates how many seconds have elapsed since 12:00 AM GMT on January 1, 1970, given a specified date and time.
|
Function |
Group |
Execution |
String Exp. |
Windows |
Windows Embedded |
IoT View |
Thin Clients |
Mobile Access |
|---|---|---|---|---|---|---|---|---|
|
DateTime2Clock |
Date and Time |
Synchronous |
Yes |
Supported |
Supported |
Not supported |
Supported |
Executed on Server |
Syntax
DateTime2Clock( strDate, strTime, optTimeZone )
DateTime2Clock ( strDate , strTime { | ,optTimeZone } )
strDate
The date to be used in the calculation, formatted according to the current date format. For more information, see About the date format and how to change it.
strTime
The time to be used in the calculation, formatted as HH:MM:SS.
optTimeZone
A time zone name (string) or index (integer).
|
Value |
Description |
|---|---|
|
-i |
A time zone index (i), up to the maximum index returned by the function GetTimeZoneCount. |
|
0 |
The current time zone in either the project runtime server or the project thin client, depending on where the function is called. This might be different from the current time zone in the local computer's system settings, if the function SetTimeZone was previously executed. |
|
1 |
Coordinated Universal Time (UTC). |
|
2 |
The current time zone in the local computer's system settings. |
|
"timezone" |
The full name of a time zone (for example, "Central Standard Time"). |
This parameter is optional; if no value is specified, the default value is 0.
Returned value
This function returns the number of seconds that have elapsed since 12:00 AM GMT on January 1, 1970, given the specified date and time. If a time zone is specified, then the number of seconds is adjusted to reflect the change from the current time zone to the specified time zone.
Notes
If this function is called in a project screen on Mobile Access, it is executed using the system clock and date/time settings on the computer that hosts the project runtime server.
Examples
Get the number of seconds elapsed when the system clock started counting:
DateTime2Clock("01/01/1970","00:00:00","Greenwich Mean Time")
Get the number of seconds elapsed at 10:59:19 AM on April 15, 2002, in the current time zone:
DateTime2Clock("04/15/2002","10:59:19")