SQL Server How to Split the day hour in shiftwise? [closed]

1bqhqjot 于 2023-04-10 发布在其他

关注(0)|答案(2)|浏览(132)

Closed. This question needs details or clarity . It is not currently accepting answers.

Want to improve this question? Add details and clarify the problem by editing this post .

Closed 4 years ago.
Improve this question

Can anyone say how to split the a day with 7 hours difference

Eg:

29/09/2018 00:00:00 -  29/09/2018 24:00:00

29/09/2018 07:00:00
29/09/2018 14:00:00
29/09/2018 21:00:00

sql-server

来源：https://stackoverflow.com/questions/52565976/how-to-split-the-day-hour-in-shiftwise

2条答案

按热度按时间

xytpbqjk1#

You could use CROSS APPLY to make one row with a date column appear 3 times, each with a different time. This can be done like this:

SELECT t.SomeDate, hrs.SplitDateTIme
FROM SomeTable t
CROSS APPLY (
    VALUES 
        (DATEADD(hour, 5, t.SomeDate)),
        (DATEADD(hour, 12, t.SomeDate)),
        (DATEADD(hour, 19, t.SomeDate))
) AS hrs(SplitDateTime);

赞(0）回复(0）举报 2023-04-10

xoefb8l82#

If you are doing it in C# You can select a Start time of a day then add 7 hours to it

var date = DateTime.Now;
var date1 = date.AddHours(7);
var date2 = date1.AddHours(7);

Inform me is that what you want .

赞(0）回复(0）举报 2023-04-10

我来回答

SQL Server How to Split the day hour in shiftwise? [closed]

2条答案

相关问题

热门标签

最新问答