Extract tickets with time. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Extract tickets with time.

Author

Topic

Makaio780
Starting Member

24 Posts

Posted - 2012-06-27 : 13:17:46

select Incident_Number,Reported_date
From vars76_Hpd_help_desk
where reported_date > @startdate and reported_date < @startdate

How can i extract tickets that are between 7am and 5pm when parameters entered are 5/1/2012 and 6/1/2012.

Ron Cheung

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2012-06-27 : 13:24:36

add
and DATEPART(Hour,ReportDate) BETWEEN 7 and 17

Jim

Everyday I learn something that somebody else already knew

Makaio780
Starting Member

24 Posts

Posted - 2012-06-27 : 13:43:46

Thanks!!!!

Ron Cheung

Makaio780
Starting Member

24 Posts

Posted - 2012-06-27 : 14:16:44

select Incident_Number,Reported_date
From vars76_Hpd_help_desk
where reported_date > '6/1/2012'
AND reported_date < '6/14/2012'
AND (((DATEPART(Hour,Reported_Date) BETWEEN 5 and 22) and (DATEPART(Weekday,Reported_date) Between 2 and 6))
Order by reported_date asc

How would i add time frame of Saturday and Sunday from 7am to 5pm?

Ron Cheung

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources