sql - 在SQL Server中将日期格式转换为DD / MMM / YYYY格式(Convert Date format into DD/MMM/YYYY format in SQL Server)

Question

I have a query in sql, I have to get date in a format of dd/mmm/yy

(我在sql中有一个查询，我必须以dd/mmm/yy的格式获取日期)

Example: 25/jun/2013 .

(示例： 25/jun/2013 。)

How can I convert it for SQL server?

(如何将其转换为SQL Server？)

  ask by Krish KvR translate from so

Answer 1

I'm not sure there is an exact match for the format you want.

(我不确定您想要的格式是否完全匹配。)

But you can get close with convert() and style 106 .

(但是你可以用convert()和style 106来接近。)

Then, replace the spaces:

(然后，替换空格：)

SELECT replace(convert(NVARCHAR, getdate(), 106), ' ', '/')