如何在SQL 2005中将日期格式转换为nvarchar [英] How to convert date formate into nvarchar in SQL 2005
问题描述
我在不同的日期sql表中有很多数据。我的日期是日期时间格式,如2016-04-31 00:00:00.000,我想在nvarchar格式转换这个日期,如31-04-2016.I我正在使用sql 2005和2008.
谢谢
问候
Praveen
我是什么尝试过:
i在sql表中有很多数据。我的日期是日期时间格式,如2016-04-31 00:00:00.000,我想在nvarchar格式转换这个日期,如31-04-2016.I我正在使用sql 2005和2008.
谢谢
关于
Praveen
你可以找到你的解决方案在这里访问它。
SQL Server CONVERT()函数 [ ^ ]
MSDN文档说明您可以使用:
CAST和CONVERT(Transact-SQL) [ ^ ]
或
FORMAT(Transact-SQL) [ ^ ]
注意:不建议这样做,除非您只想将其转换为显示目的<!/ BLOCKQUOTE>
i have lot of data in different different date sql table. i have date is in date time format like 2016-04-31 00:00:00.000 and i want convert this date on nvarchar format like 31-04-2016.I am using sql 2005 and 2008.
thank
with regards
Praveen
What I have tried:
i have lot of data in sql table. i have date is in date time format like 2016-04-31 00:00:00.000 and i want convert this date on nvarchar format like 31-04-2016.I am using sql 2005 and 2008.
thank
with regards
Praveen解决方案You can found your solution here visit it.
SQL Server CONVERT() Function[^]
MSDN documentation states that you can use:
CAST and CONVERT (Transact-SQL)[^]
or
FORMAT (Transact-SQL)[^]
Note: this is not recommended, unless you want to convert it only for display purposes!
这篇关于如何在SQL 2005中将日期格式转换为nvarchar的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!