SQL Date Format examples using SQL FORMAT Function - SQL Server …
https://www.mssqltips.com/sqlservertip/2655/format-sql-server-dates-with-format-function/
WebMay 1, 2012 · Use the FORMAT function to format the date and time data types from a date column (date, datetime, datetime2, smalldatetime, datetimeoffset, etc. data type) in a table or a variable such as GETDATE () To get DD/MM/YYYY use SELECT FORMAT (getdate (), 'dd/MM/yyyy ') as date. To get MM-DD-YY use SELECT FORMAT (getdate (), 'MM-dd-yy') …
DA: 36 PA: 68 MOZ Rank: 97