DAYOFWEEK — различия между версиями
Hisava (обсуждение | вклад) м |
Hisava (обсуждение | вклад) м |
||
| (не показана одна промежуточная версия этого же участника) | |||
| Строка 5: | Строка 5: | ||
Syntax | Syntax | ||
| − | DAYOFWEEK(<dDate>) | + | [[DAYOFWEEK]](<dDate>) -> nDay |
Parameters | Parameters | ||
| Строка 13: | Строка 13: | ||
Return Values | Return Values | ||
| − | DAYOFWEEK() returns a number in the range of 1 to 7 as an integer numeric value. If the date argument is empty, DAYOFWEEK() returns zero. | + | [[DAYOFWEEK]]() returns a number in the range of 1 to 7 as an integer numeric value. If the date argument is empty, DAYOFWEEK() returns zero. |
Remarks | Remarks | ||
| − | DAYOFWEEK() is a date conversion function used to convert a date value to the numeric day of week value and can be used in various date calculations. | + | [[DAYOFWEEK]]() is a date conversion function used to convert a date value to the numeric day of week value and can be used in various date calculations. |
Note Advantage Expression Engine functions can be used in expressions such as record filter expressions and index expressions. They are not necessarily scalars supported within SQL statements. For a list of supported SQL scalar functions, see Supported Scalar Functions. | Note Advantage Expression Engine functions can be used in expressions such as record filter expressions and index expressions. They are not necessarily scalars supported within SQL statements. For a list of supported SQL scalar functions, see Supported Scalar Functions. | ||
Текущая версия на 14:42, 19 сентября 2018
DAYOFWEEK - это функция ADS
Advantage Expression Engine function that returns the numeric day of a date value
Syntax
DAYOFWEEK(<dDate>) -> nDay
Parameters
<dDate> A date value to convert.
Return Values
DAYOFWEEK() returns a number in the range of 1 to 7 as an integer numeric value. If the date argument is empty, DAYOFWEEK() returns zero.
Remarks
DAYOFWEEK() is a date conversion function used to convert a date value to the numeric day of week value and can be used in various date calculations.
Note Advantage Expression Engine functions can be used in expressions such as record filter expressions and index expressions. They are not necessarily scalars supported within SQL statements. For a list of supported SQL scalar functions, see Supported Scalar Functions.
