SQL Syntaz 1

[SQLneube]

Helppppp

I need to retrieve all the events that happened between June and December from a table(I don’t care about the year). What syntax would I use?


thanks
SQLNeubie

 

[SQLDenis]

select * from dbo.table where
datepart(m,QueryDate) between 6 and 12

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[SQLneube]

sorry, I need to retrieve the events that happens in 6 or 12 not between 6 and 12.

what syntax would I use

 

[SQLDenis]

Something like this?

select * from dbo.table
where dateadd(m,6,QueryDate()) =getdate()
or
dateadd(m,12,QueryDate()) =getdate()


or is this what you are looking for??

select * from dbo.table where

QueryDate = dateadd(m,6,QueryDate())
or
QueryDate = dateadd(m,12,getdate())

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[SQLneube]

Can I query like this -

select * from dbo.table
where datepart(mm,query_date)= 6 or
datePart(mm,query_date) = 12
and can I add this select statement as a subquery and how would I do that?

thanks
SQLNeube

 

[SQLneube]

When I tried the 2nd select statement...it returns that QueryDate()is not known.

What should I put in place of QueryDate?

Thanks

 

[SQLDenis]

query_date would be the name of the datetime filed in your Table

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/