Difference between revisions of "EncodeTime"
m |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 3: | Line 3: | ||
The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight. | The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight. | ||
| − | + | == Usage == | |
| + | <syntaxhighlight>EncodeTime(HH, mm, ss, mmm)</syntaxhighlight> | ||
| − | + | Where: | |
| + | |||
| + | :'''HH''' - a numerical expression specifying the hours in 24-hour format. | ||
| + | :'''mm''' - a numerical expression specifying the minutes. | ||
| + | :'''ss''' - a numerical expression specifying the seconds. | ||
| + | :'''mmm''' - a numerical expression specifying the milliseconds. | ||
| + | |||
| + | == Notes == | ||
| + | * Use [[EncodeDate]] to return the integer portion of a double-precision decimal DateTime value corresponding to a specified date. | ||
| + | |||
| + | == Example == | ||
| + | <syntaxhighlight>EncodeTime(16, 29, 55, 500)</syntaxhighlight> | ||
| + | Will return a value of 0.6874479167, corresponding to the specified time of 16:29:55.500. | ||
| + | |||
| + | [[Category:Date and Time Routines]] | ||
Latest revision as of 13:06, 19 February 2012
Returns the fractional portion of a double-precision decimal DateTime value corresponding to the specified time.
The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight.
Usage
EncodeTime(HH, mm, ss, mmm)
Where:
- HH - a numerical expression specifying the hours in 24-hour format.
- mm - a numerical expression specifying the minutes.
- ss - a numerical expression specifying the seconds.
- mmm - a numerical expression specifying the milliseconds.
Notes
- Use EncodeDate to return the integer portion of a double-precision decimal DateTime value corresponding to a specified date.
Example
EncodeTime(16, 29, 55, 500)
Will return a value of 0.6874479167, corresponding to the specified time of 16:29:55.500.