I started with "between", but when this didn't work, I switched to the
comparison operators.
mysql> select projects.name from projects
-> where projects.closeddate between :fd and :td;
ERROR 1064: You have an error in your SQL syntax near ':fd and :td' at line
2
mysql>
-----Original Message-----
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 4:04 PM
To: Noamn; [EMAIL PROTECTED]
Subject: RE: Comparing date fields
[snip]
I'm in the process of converting an application from Paradox to mySQL
which
is why I have these syntax questions.
mySQL doesn't like a query with this syntax:
select p.name, ....
from projects p, ...
where p.closeddate >= :fd
and p.closeddate <= :td
...
where fd ("from date") and td ("till date") are parameters. Can one use
greater than/less than operators, or is there some other way of
filtering
only those records with closeddates in the range that I specify?
[/snip]
You can use BETWEEN (which is inclusive of the dates specified)
select p.name, ....
from projects p, ...
where p.closeddate BETWEEN date AND date
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
