Subject | Select with dates |
---|---|
Author | Jorez A. Nasato |
Post date | 2002-12-27T13:45:29Z |
Hi!
I'm trying to do the folow select:
select * from table where data between '12/01/2002' and '12/23/2002'
And in the table I have:
code------data--------------text
1 23/12/2002 xxxxxxxx
2 24/12/2002 yyyyyyyyy
So, when I execute the select, its returns null, could someone help, I'm using FB and the database was created with dialect 1.
Thanks
[Non-text portions of this message have been removed]
I'm trying to do the folow select:
select * from table where data between '12/01/2002' and '12/23/2002'
And in the table I have:
code------data--------------text
1 23/12/2002 xxxxxxxx
2 24/12/2002 yyyyyyyyy
So, when I execute the select, its returns null, could someone help, I'm using FB and the database was created with dialect 1.
Thanks
[Non-text portions of this message have been removed]