Difference between revisions of "HoursFromDateTime"
Jump to navigation
Jump to search
(→Usage) |
m (Reverted edits by 176.8.90.7 (talk) to last revision by 194.84.116.138) |
||
| Line 3: | Line 3: | ||
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>HoursFromDateTime(DateTime)</syntaxhighlight> | ||
| + | Where: [[DateTime]] - a double-precision decimal DateTime value | ||
| + | |||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight>HoursFromDateTime(39449.85000000) will return a value of 20, indicating 8 PM</syntaxhighlight> | <syntaxhighlight>HoursFromDateTime(39449.85000000) will return a value of 20, indicating 8 PM</syntaxhighlight> | ||
Latest revision as of 13:12, 13 February 2012
Returns a numerical value indicating the hours from the specified DateTime value. The hours are indicated in the 24-hour format, where 13 = 1 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
HoursFromDateTime(DateTime)
Where: DateTime - a double-precision decimal DateTime value
Example
HoursFromDateTime(39449.85000000) will return a value of 20, indicating 8 PM
