Probably a noob query question! Chosing date range.

[iPixel]

So i need to pull data from a table and the query should go something like this.

 

SELECT * FROM tablename WHERE Date is between 01-JUN-09 to 18-Jun-09

 

How do i write the bold part... im not sure how the range thing works.

 

Thanks.

[Maq]

So i need to pull data from a table and the query should go something like this.

 

SELECT * FROM tablename WHERE Date is between 01-JUN-09 to 18-Jun-09

 

How do i write the bold part... im not sure how the range thing works.

 

Thanks.

 

Your date field has to be either type 'date' or 'timestamp'.  It can't be a varchar.

[iPixel]

The field is DATE type, and it contains info in this format  DD-MON-YY.

Bah im an idiot, i posted this on MySQL when it's an Oracle database LOLz.

But i guess there might be enough similarities for me to figure out once i know the MySQL query.

[PFMaBiSmAd]

And the BETWEEN ... AND ... syntax http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_between does not use the words "is" and "to" (I know you were asking in pseudo code, but the documentation exists for a reason - so that you can research the basics yourself.)

 

Edit: mysql forum questions get mysql answers.

[Maq]

It's basically the same syntax, simple Google search could have solved this.  between

 

 

[iPixel]

I suck at knowing what phrase to use in order to get my results haha.

Thanks Guys! I'll check out the link.