How to convert date into dd-mm-yyyy format in SQL server?

Question

Can anyone tell me how to convert date into dd-mm-yyyy format in the SQL server?

Answer 1

We can use CONVERT function to convert the date from one format to another. Here is the statement to convert the date into dd-mm-yyyy format in SQL server:

SELECT CONVERT (varchar, getdate(), 105);

You can learn more about date format and date functions from this SQL tutorial by Intellipaat

You can learn in-depth about SQL statements, queries and become proficient in SQL queries by enrolling in our industry-recognized SQL online course.