Subject | selecting any day older than some day with between |
---|---|
Author | Sergio |
Post date | 2013-05-07T13:42:16Z |
Hello, I'm using FB 2.5
In the manual says that the date type goes from 01-01-100 to 31-12-9999
so, can I be *sure* that this select will bring all records older than a given date?
select * from my_table where my_date between '01-01-100' and :some_date
I'm using between and not my_date < :some_date because it's a genereic select inside a SP and sometimes I need the "from_date"
Thanks!
Sergio
In the manual says that the date type goes from 01-01-100 to 31-12-9999
so, can I be *sure* that this select will bring all records older than a given date?
select * from my_table where my_date between '01-01-100' and :some_date
I'm using between and not my_date < :some_date because it's a genereic select inside a SP and sometimes I need the "from_date"
Thanks!
Sergio