Difference between revisions of "DateTime2ELTime"
Jump to navigation
Jump to search
(→Usage) |
|||
| (3 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
Returns a numerical value indicating the time from the specified DateTime value. The time is indicated in the 24-hour HHmm format, where 1300 = 1:00 PM. | Returns a numerical value indicating the time from the specified DateTime value. The time is indicated in the 24-hour HHmm format, where 1300 = 1:00 PM. | ||
| − | The integer portion of the DateTime value specifies the number of days since | + | The integer portion of the DateTime value specifies the number of days since December 30th, 1899, and the fractional portion of the DateTime value specifies the fraction of the day since midnight. |
| − | + | == Usage == | |
| + | <syntaxhighlight>DateTime2ELTime(DateTime)</syntaxhighlight> | ||
| − | + | Where: | |
| − | + | ||
| − | + | :'''DateTime''' - a double-precision decimal DateTime value. | |
| + | == Notes == | ||
| + | * Use [[ELTimeToDateTime_s]] or [[ELTimeToDateTime]] to convert a DateTime value to PowerLanguage's default time format of 130000 for 1:00:00 PM. | ||
| + | * Use [[DateTime2ELTime_s]] to convert a PowerLanguage time to a DateTime value ''with'' seconds precision. | ||
| + | == Example == | ||
| + | <syntaxhighlight>DateTime2ELTime(39449.65625000)</syntaxhighlight> | ||
| + | Will return a value of 1545, indicating 3:45 PM. | ||
[[Category:Date and Time Routines]] | [[Category:Date and Time Routines]] | ||
Latest revision as of 13:33, 15 February 2023
Returns a numerical value indicating the time from the specified DateTime value. The time is indicated in the 24-hour HHmm format, where 1300 = 1:00 PM.
The integer portion of the DateTime value specifies the number of days since December 30th, 1899, and the fractional portion of the DateTime value specifies the fraction of the day since midnight.
Usage
DateTime2ELTime(DateTime)
Where:
- DateTime - a double-precision decimal DateTime value.
Notes
- Use ELTimeToDateTime_s or ELTimeToDateTime to convert a DateTime value to PowerLanguage's default time format of 130000 for 1:00:00 PM.
- Use DateTime2ELTime_s to convert a PowerLanguage time to a DateTime value with seconds precision.
Example
DateTime2ELTime(39449.65625000)
Will return a value of 1545, indicating 3:45 PM.
