Using FORMAT()

Unlike the CONVERT() function, the FORMAT() function takes in the format as a string as such 'dd/MM/yyyy'.

You need to get a report of all the pilots. You realize that the format of the entry_date column is 'yyyy-MM-dd', and you want to show the results in the format of 'dd/MM/yyyy'. As this table contains few data, you think about using the FORMAT() function.

Notice that the type of the entry_date column is VARCHAR(10) and not a date.

This exercise is part of the course

Cleaning Data in SQL Server Databases

View Course

Exercise instructions

Convert the type of the entry_date column to DATE and print it in 'dd/MM/yyyy' format.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT 
	pilot_code,
	pilot_name,
	pilot_surname,
	carrier_code,
    -- Convert the entry_date to a DATE and print it in dd/MM/yyyy format
	___(___(entry_date AS DATE), '___/___/___') AS entry_date
from pilots

Edit and Run Code