Difference between revisions of "DateTime2ELTime s"
Jump to navigation
Jump to search
m (Reverted edits by 176.8.90.7 (talk) to last revision by 194.84.116.138) |
|||
| Line 1: | Line 1: | ||
| − | Returns a numerical value indicating the time, including seconds, from the specified DateTime value. The time is indicated in the 24-hour HHmmss format, where 130000 = 1:00:00 PM. | + | Returns a numerical value indicating the time, including seconds, from the specified DateTime value. The time is indicated in the 24-hour ''HHmmss'' format, where 130000 = 1:00:00 PM. |
The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight. | The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight. | ||
| − | + | == Usage == | |
<syntaxhighlight>DateTime2ELTime_s (DateTime)</syntaxhighlight> | <syntaxhighlight>DateTime2ELTime_s (DateTime)</syntaxhighlight> | ||
| − | Where: | + | 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. | ||
| + | == Example == | ||
| + | <syntaxhighlight>DateTime2ELTime_s(39449.646354167)</syntaxhighlight> | ||
| + | Will return a value of 153045, indicating 3:30:45 PM. | ||
[[Category:Date and Time Routines]] | [[Category:Date and Time Routines]] | ||
Revision as of 12:46, 19 February 2012
Returns a numerical value indicating the time, including seconds, from the specified DateTime value. The time is indicated in the 24-hour HHmmss format, where 130000 = 1:00:00 PM.
The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight.
Usage
DateTime2ELTime_s (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.
Example
DateTime2ELTime_s(39449.646354167)
Will return a value of 153045, indicating 3:30:45 PM.
