如何转换日期时间格式使用Sql server 2005添加时间值 [英] How to Convert Datetime Format Add to time Value using Sql server 2005
问题描述
亲爱的先生,
Sqlserver查询以下查询。运行Sql server 2008已成功运行。
SELECT @ChkFromDate = CAST(''2015-02-02 00:00:00.000''AS DATETIME)+ CAST( '07:30'AS DATETIME)
以上查询结果为2015-02-02 07:30:00.000。
我在sqlserver 2005运行中尝试了以上查询但是错误来了。所以如何得到这个结果(2015-02-02 07:30:00.000),所以如何加入日期与时间添加在Sql server 2005.
谢谢
< blockquote>我认为这就是你要找的东西: DATEADD [ ^ ]
试试这个:
SELECT CONVERT ( VARCHAR ,DATEADD(s,(DATEPAR T(HOUR,' 07:30')* 3600 )+
(DATEPART(MINUTE,' 07:30')* 60 ),' 2015-02-02 00:00 :00.000'), 121 )
Dear Sir,
Sqlserver Query bellow query. Running Sql server 2008 was successfully Runned.
SELECT @ChkFromDate = CAST(''2015-02-02 00:00:00.000'' AS DATETIME) + CAST('07:30' AS DATETIME)
This above query result is 2015-02-02 07:30:00.000.
I am tried above query in sqlserver 2005 running but error came.so how to get this result in (2015-02-02 07:30:00.000) ,so how to join date with time add in Sql server 2005.
Thanks
I think this is what you are looking for: DATEADD[^]
Try this:
SELECT CONVERT(VARCHAR, DATEADD(s, (DATEPART(HOUR, '07:30') * 3600) + (DATEPART(MINUTE, '07:30') * 60), '2015-02-02 00:00:00.000'), 121)
这篇关于如何转换日期时间格式使用Sql server 2005添加时间值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!