---
title: "How to change the date format in SQL Server?"  
description: "How to change the date format in SQL Server?"  
author: "Ashutosh Patel"  
published: 2024-10-15  
updated: 2024-10-15  
canonical: https://www.mindstick.com/interview/33972/how-to-change-the-date-format-in-sql-server  
category: "mssql server"  
tags: ["mssql server", "sql server", "sql"]  
reading_time: 1 minute  

---

# How to change the date format in SQL Server?

In SQL Server, you can use the `FORMAT` function or `CONVERT` function to change the Date format. Some of them are given below,\
Sample SQL Table: ‘Employees’ with the columns “EmpId, EmpName, CreationDate, Gender, Salary”

![How to change the date format in SQL Server?](https://www.mindstick.com/interviewquestion/34268a13-e8dd-4ddb-ba4e-7e6c230ee483/images/e8461e79-e592-405a-ab08-cb2c73c26e2a.png)

## Example-

Using FORMAT()

![How to change the date format in SQL Server?](https://www.mindstick.com/interviewquestion/34268a13-e8dd-4ddb-ba4e-7e6c230ee483/images/9ce5249b-acf7-41fc-9e04-fc2d14da2328.png)

Using CONVERT()

1.

![How to change the date format in SQL Server?](https://www.mindstick.com/interviewquestion/34268a13-e8dd-4ddb-ba4e-7e6c230ee483/images/c9a3471d-183b-4f07-beaa-ab7c2add9162.png)

2.

![How to change the date format in SQL Server?](https://www.mindstick.com/interviewquestion/34268a13-e8dd-4ddb-ba4e-7e6c230ee483/images/2a869d62-8fff-4e91-9931-5250f65613b6.png)

## Answers

### Answer by Ashutosh Patel

In SQL Server, you can use the `FORMAT` function or `CONVERT` function to change the Date format. Some of them are given below,\
Sample SQL Table: ‘Employees’ with the columns “EmpId, EmpName, CreationDate, Gender, Salary”

![How to change the date format in SQL Server?](https://www.mindstick.com/interviewquestion/34268a13-e8dd-4ddb-ba4e-7e6c230ee483/images/e8461e79-e592-405a-ab08-cb2c73c26e2a.png)

## Example-

Using FORMAT()

![How to change the date format in SQL Server?](https://www.mindstick.com/interviewquestion/34268a13-e8dd-4ddb-ba4e-7e6c230ee483/images/9ce5249b-acf7-41fc-9e04-fc2d14da2328.png)

Using CONVERT()

1.

![How to change the date format in SQL Server?](https://www.mindstick.com/interviewquestion/34268a13-e8dd-4ddb-ba4e-7e6c230ee483/images/c9a3471d-183b-4f07-beaa-ab7c2add9162.png)

2.

![How to change the date format in SQL Server?](https://www.mindstick.com/interviewquestion/34268a13-e8dd-4ddb-ba4e-7e6c230ee483/images/2a869d62-8fff-4e91-9931-5250f65613b6.png)


---

Original Source: https://www.mindstick.com/interview/33972/how-to-change-the-date-format-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.