Format SQL DATE to UK Date

PHOTO EMBED

Tue Feb 15 2022 11:37:37 GMT+0000 (Coordinated Universal Time)

Saved by @paulbarry #sql

SELECT Suref, FORMAT(DateFrom, 'd', 'en-gb') AS 'Great Britain English format'
FROM [dbo].[BOCClientIndex - AdultServiceDetails]
WHERE [DateFrom] >= '01/01/2020'
Order by DateFrom
content_copyCOPY