如何格式化dateadd SQLServer? [英] How to format dateadd SQLServer?
本文介绍了如何格式化dateadd SQLServer?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,我试试。
选择 dateadd(day, 30 ,' 2014-09-01') as EXPDATE
但显示如下
2014-10-01 00:00 :00。 000
我只想这样
2014-10- 01
感谢您的回答。
解决方案
返回的是日期
,其显示取决于您如何格式化以供查看。
您可以使用FORMAT
但它会给你一个字符串而不是日期类型: http://www.w3schools。 com / sql / sql_func_format.asp [ ^ ]
默认情况下,字符串将转换为
datetime
类型。首先尝试将其显式转换为日期
: 选择 dateadd(day, 30 ,CAST(' 2014-09-01' as date )) as EXPDATE
Hi everybody, I'm try.
select dateadd(day, 30, '2014-09-01') as EXPDATE
but it display like this
2014-10-01 00:00:00.000
I just want like this
2014-10-01
Thank you for answer.
解决方案
What is being returned is adate
, the display of which depends on how you format it for viewing.
You can useFORMAT
but it will give you a string as a result not a date type : http://www.w3schools.com/sql/sql_func_format.asp[^]
The string is being converted to adatetime
type by default. Try explicitly converting it to adate
first:
select dateadd(day, 30, CAST('2014-09-01' as date)) as EXPDATE
这篇关于如何格式化dateadd SQLServer?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文