The style Parameter

The style parameter of CONVERT provides a wide variety of date display formats when converting datetime data to char or varchar. The number you supply as the style parameter determines how the datetime data is displayed. The year can be displayed in either two or four digits. Add 100 to a style value to get a four-place year, including the century (yyyy).

The following example shows CONVERT with the style parameter:

SELECT CONVERT(char(12), GETDATE(), 3)

This statement converts the current date to style 3, dd/mm/yy. For more information about the values for the style parameter, see Functions in the Microsoft SQL Server Transact-SQL Reference.