MS Access Format() 函数

将 "BirthDate" 列设置为长日期：

SELECT Format(BirthDate, "Long Date") AS FormattedBirthDate
FROM Employees;

定义和用法

Format() 函数使用指定的格式格式化日期值。

Format( value, format, firstdayofweek, firstweekofyear)

Parameter

Description

value

Required. The date value to format

format

Optional. The format to use.

Format	Description
General Date	Shows value as a date based on the system settings
Long Date	Shows value as a date based on the system's long date settings
Medium Date	Shows value as a date based on the system's medium date settings
Short Date	Shows value as a date based on the system's short date settings
Long Time	Shows value as a date based on the system's long time settings
Medium Time	Shows value as a date based on the system's medium time settings
Short Time	Shows value as a date based on the system's short time settings

firstdayofweek

Optional. Specifies the first day of the week. Can be one of the following values:

firstdayofyear

Optional. Specifies the first week of the year. Can be one of the following values:

工作于：	从 Access 2000