How to change the date format in SQL Server?
Ask by Ashutosh Patel
Updated 15 Oct 2024
In SQL Server, you can use the
FORMATfunction orCONVERTfunction to change the Date format. Some of them are given below,Sample SQL Table: ‘Employees’ with the columns “EmpId, EmpName, CreationDate, Gender, Salary”
Example-
Using FORMAT()
Using CONVERT()
1.
2.