Hàm Định dạng MS Access ()
Thí dụ
Định dạng cột "Ngày sinh" thành một ngày dài:
SELECT Format(BirthDate, "Long Date") AS FormattedBirthDate
FROM Employees;
Định nghĩa và Cách sử dụng
Hàm Format () định dạng giá trị ngày tháng với định dạng được chỉ định.
Cú pháp
Format(value, format, firstdayofweek, firstweekofyear)
Giá trị tham số
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:
- 0 = Use the NLS API setting
- 1 = Sunday (this is default)
- 2 = Monday
- 3 = Tuesday
- 4 = Wednesday
- 5 = Thursday
- 6 = Friday
- 7 = Saturday
|
firstdayofyear |
Optional. Specifies the first week of the year. Can be one of the following values:
- 0 = Use the NLS API setting
- 1 = Use the first week that includes Jan 1st (default)
- 2 = Use the first week in the year that has at least 4 days
- 3 = Use the first full week of the year
|
Chi tiết kỹ thuật
Hoạt động trong: |
Từ Access 2000 |