Difference between revisions of "DayOfWeekFromDateTime"
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 day of the week corresponding to the specified DateTime value, where 0 = Sunday, 1 = Monday, | + | Returns a numerical value, indicating the day of the week corresponding to the specified DateTime value, where 0 = Sunday, 1 = Monday, 2 = Tuesday, 3 = Wednesday, 4 = Thursday, 5 = Friday and 6 = Saturday. |
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>DayOfWeekFromDateTime(DateTime)</syntaxhighlight> | <syntaxhighlight>DayOfWeekFromDateTime(DateTime)</syntaxhighlight> | ||
− | Where: | + | Where: |
− | + | ||
− | + | :'''DateTime''' - a double-precision decimal DateTime value. | |
− | |||
− | |||
+ | == Examples == | ||
+ | <syntaxhighlight>DayOfWeekFromDateTime(39448.25000000)</syntaxhighlight> | ||
+ | Will return a value of 2, indicating Tuesday, for January 1st, 2008. | ||
+ | <syntaxhighlight>DayOfWeekFromDateTime(ComputerDateTime)</syntaxhighlight> | ||
+ | Returns a value of 0, indicating that today is a Sunday. | ||
[[Category:Date and Time Routines]] | [[Category:Date and Time Routines]] |
Revision as of 12:28, 19 February 2012
Returns a numerical value, indicating the day of the week corresponding to the specified DateTime value, where 0 = Sunday, 1 = Monday, 2 = Tuesday, 3 = Wednesday, 4 = Thursday, 5 = Friday and 6 = Saturday.
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
DayOfWeekFromDateTime(DateTime)
Where:
- DateTime - a double-precision decimal DateTime value.
Examples
DayOfWeekFromDateTime(39448.25000000)
Will return a value of 2, indicating Tuesday, for January 1st, 2008.
DayOfWeekFromDateTime(ComputerDateTime)
Returns a value of 0, indicating that today is a Sunday.