SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Added Date Range of Sat and Sun from 7am -5pm		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Makaio780
Starting Member

Canada
24 Posts
Posted - 06/27/2012 :  15:35:04  Show Profile  Reply with Quote
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

jimf
Flowing Fount of Yak Knowledge

USA
2865 Posts
Posted - 06/27/2012 :  17:01:01  Show Profile  Reply with Quote
add

or (DATEPART(hour,Reported_Date) BETWEEN 7 and 17 and DATEPART(Weekday,Reported_date) in (1,7)
)

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

JadeV
Yak Posting Veteran

Canada
62 Posts
Posted - 07/12/2012 :  12:19:10  Show Profile  Reply with Quote
Hi ,
How can you define the Reported_date where the Reported_date does not have available field in the database?
For example:
StartDate
EndDate

I want to have a field DurationDate between StartDate and EndDate to check for the weekend day and holidays?

How would I do?

Jade
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000