开始时间需要加上时差

发布于 2024-11-24 23:57:23 字数 433 浏览 9 评论 0原文

我希望有人能帮助我解决这个问题。我有两个日期时间开始和结束时间。我得到了两者之间的时差。例如。

Start Time   18/07/2011 08:49:48
End time     18/07/2011 08:49:52         
Diff         +000000000 00:00:04.000000000 ( 04 seconds)

我需要像这样将这个时间差添加到开始时间

 18/07/2011 08:49:48 
,18/07/2011 08:49:49
,18/07/2011 08:49:50
,18/07/2011 08:49:51
,18/07/2011 08:49:52

简单来说，需要将时间差一一添加到开始时间。这样我需要做一些其他的计算。

提前致谢。

原文

I hope any one will help me with this.
I have two datetime start and end time . I get the time difference between two.
eg.

Start Time   18/07/2011 08:49:48
End time     18/07/2011 08:49:52         
Diff         +000000000 00:00:04.000000000 ( 04 seconds)

i need to add this time difference to the start time like this

 18/07/2011 08:49:48 
,18/07/2011 08:49:49
,18/07/2011 08:49:50
,18/07/2011 08:49:51
,18/07/2011 08:49:52

In simple words , Need to add the time difference to the start time one by one. With that i need to do some other calculation.

Thanks in advance.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

涙—继续流 2024-12-01 23:57:23

SELECT  CAST('18/07/2011 08:49:48' AS DATE) + (level - 1) / 86400
FROM    dual
CONNECT BY
        level <= (CAST('18/07/2011 08:49:52' AS DATE) - CAST('18/07/2011 08:49:48' AS DATE)) * 86400 + 1

SELECT  CAST('18/07/2011 08:49:48' AS DATE) + (level - 1) / 86400
FROM    dual
CONNECT BY
        level <= (CAST('18/07/2011 08:49:52' AS DATE) - CAST('18/07/2011 08:49:48' AS DATE)) * 86400 + 1

回复收藏 0 原文

~没有更多了~