Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to find the morning and afternoon data in sqlserver", which is easy to understand and well-organized. I hope it can help you solve your doubts. Let me lead you to study and learn this article "how to find the morning and afternoon data in sqlserver".

The DATEPART () function returns a separate part of the date / time, such as year, month, day, hour, minute, and so on.

The DATEDIFF () function returns the time difference between two dates.

-- find the data of that morning select * from R_Attendance where (datepart (hour,RDatetime) > = 0 and datepart (hour,RDatetime) 12 and datepart (hour,RDatetime))

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.