目录

MS Access WeekdayName() 函数

示例

根据数字返回工作日名称:

SELECT WeekdayName(3);

定义和用法

WeekdayName() 函数根据数字返回工作日名称。

语法

WeekdayName( number, abbreviate, firstdayofweek)

参数值

Parameter Description
number Required. A value from 1 to 7, that represent the day of the week
abbreviate Optional. A Boolean value. True = the weekday name should be abbreviated. False = the weekday name should not be abbreviated. False is default
firstdayofweek Optional. Specifies the first day of the week. Can be one of the following values:
  • 0 = Use the NLS API setting
  • 1 = Sunday (default)
  • 2 = Monday
  • 3 = Tuesday
  • 4 = Wednesday
  • 5 = Thursday
  • 6 = Friday
  • 7 = Saturday

技术细节

工作于: 从 Access 2000

更多示例

示例

根据数字返回缩写的工作日名称:

SELECT WeekdayName(3, true);

示例

根据数字返回缩写的工作日名称,并让星期一为一周的第一天:

SELECT WeekdayName(3, true, 2);