Inbetween dates...

[The_Chancer]

I have a query that looks for any entry placed in the database between two dates (timestamp) in a varchar column, but it doesn't work... (suprise suprise)

Any takers ?

SELECT * FROM ENQUIRY WHERE agtco_name='A Name' AND enquiry_type in('Enquiry','Provisional','Confirmed','Cancelled','Released','Regretted')

that bit works OK and will pull all the required results, but how do I put

AND timestamp is inbetween $start and $end

Thanks...

[ultraslacker]

AND timestamp BETWEEN '$start' AND '$end'

[The_Chancer]

If my legs were longer I would kick myself...

How infuriatingly simple...

<sigh>Many thanks Ultraslacker...

[[deleted]]

Just a quick note: Be carefull with BETWEEN, some databases include the give values (BETWEEN A AND B means the value van be =A or >A and <B or =B, whereas others exclude the values and it's just >A and <B.

It's the old "upto" or "upto and including" problem which can really annoy you when working with dates.