Posted by Jack Vamvas on 03/18/07 08:50

Something like : SELECT myCol1 FROM myTable WHERE DATEPART(mm, Dates) =
'<insert month>',DATEPART(yy, Dates) = '<insert year>'



--

Jack Vamvas
___________________________________
Advertise your IT vacancies for free at - http://www.ITjobfeed.com



"Eugene Anthony" <solomon_13000@yahoo.com> wrote in message
news:45f99426$0$502$815e3792@news.qwest.net...
>I have a table that has a DateTime column which uses a DataTime
> datatype. How do I retrieve a range of records based on the month and
> year using ms sql?
>
> Eugene Anthony
>
> *** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Transaction not rolling back
• Prev in forum: Re: Change connected user to avoid owner prefix in queries
• Thread view: Re: selecting records based on date

[Reply to this message]