How to change date format of yyyy-dd-mm in SQL Server?
I have tried to change the format using formatting string but format didn't change
hmae6n7t1#
The date format can be changed using Date and Time Conversions in sql server. The required format could be achieved by using CONVERT(varchar, date_column,31) in your script.
https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/
Please refer above link for another format.
1条答案
按热度按时间hmae6n7t1#
The date format can be changed using Date and Time Conversions in sql server. The required format could be achieved by using CONVERT(varchar, date_column,31) in your script.
https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/
Please refer above link for another format.