Format – Access Function

The FORMAT function lets you format any string or date to a specified format in an SQL Query.

The syntax for the FORMAT function is:

FORMAT ( string1, format )

string1 is the string to format

format is the format specified that will be returned.

Example #1:

select FORMAT(start_date, ‘DD/MM/YYYY’)
from suppliers;