SQL Query

I’m writing this query and i can’t seem to pull one month’s worth of data.  

SELECT intr_loc, intr_idcode, intr_item, intr_date, intr_issued, intr_unit_price, intr_req_no, intr_po_no, intr_whmd_wo_num, intr_wo_task, intr_trno, intr_trtype, intr_trcode, intr_convert
FROM intrhist

I’ve tried a TON of syntaxes in ‘WHERE’ but i can’t get it to return one month’s worth of data.  I can get it to return ONE YEAR’s worth but that’s kind of difficult to work with.  

WHERE intr_date = '2012-10-10' or '2012-10-01'
WHERE intr_date >= 2012-12-01 OR intr_date <= 2012-12-31
WHERE intr_date LIKE '[2012-06]%'
WHERE intr_date LIKE ‘2012-10________________’

The date field is formatted like this:  2012-05-11 00:00:00.000


How can i do that?
Josh HindSystems AdminAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
tim_csConnect With a Mentor Commented:
Make sure to put single quotes around the dates and try zephyr_hex's example again.

WHERE intr_date >= '2012-12-01' AND intr_date <= '2012-12-31'
0
 
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
try this:
WHERE intr_date >= 2012-12-01 AND intr_date <= 2012-12-31
0
 
Josh HindSystems AdminAuthor Commented:
That doesn't return any data.  It compiles but after it executes the results are empty.
0
 
Josh HindSystems AdminAuthor Commented:
THANK YOU!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.