Board index » delphi » SQL - from DATE to DATE

2005-05-27 12:52:29 AM
delphi170
Hi!
I have a SQL like:
select * from mytable where mydate between (:from_date and :to_date)
I want to select *ALL* records less or equal than today. Can I do ?
Params[0].AsDate := 0
Params[1].AsDate := date
So far it seems to work fine. But I would like to be sure if this is a good way
to do it.
And what if I want to select *ALL* records ?
Params[0].AsDate := 0
Params[1].AsDate := ????
I'd like to avoid the use of OR clauses like:
select * from mytable where mydate between (:from_date and :to_date)
or :all = -1
Thanks!
Sergio
 

How about select * from mytable where mydate<=current_date?
Sergio Gonzalez writes:

"Quinn Wildman" <XXXX@XXXXX.COM>escribi?en el mensaje
Sometimes I need to ask for records between dates and sometimes I just want
to bring all the records.
I know that I can change the SQL statement, but I was wandering if I can do
that with my original SQL
Thanks again!
Sergio
 

Just use appropriately wide limits, e.g. to get everything
select data between years 1000 and 3000.
so the best is to use only those conditions in Where clause that you really need, i.e.
select * from mytable where mydate between (:from_date and :to_date)
select * from mytable where mydate < :to_date
select * from mytable ... to get all records.
Ivan