Loading lesson path
Concept visual
Start at both ends
Format the "BirthDate" column to a long date:
SELECT Format(BirthDate, "Long Date") AS FormattedBirthDate
FROM Employees;The Format() function formats a date value with the specified format.
value, format, firstdayofweek, firstweekofyear )
Required. The date value to format format Optional. The format to use.
Shows value as a date based on the system settings
Shows value as a date based on the system's long date settings
Shows value as a date based on the system's medium date settings
Shows value as a date based on the system's short date settings
Shows value as a date based on the system's long time settings
Shows value as a date based on the system's medium time settings
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:
Formula
0 = Use the NLS API setting
1 = Sunday (this is default)
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday firstdayofyearOptional. Specifies the first week of the year. Can be one of the following values:
Formula
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❮ MS Access Functions