| Subject | Re: [firebird-support] Execute Statement and Date type |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-06-18T12:19:11Z |
At 10:52 AM 18/06/2004 +0000, you wrote:
Sorry, copy-pasted too fast. You can't use the date types in a string
without casting them.
sql='select orderdate, count(*) from orders where orderdate between '''
|| cast(mindate as char(11)) ||''' and '''||cast(maxdate as char(11)
||''' and '||additionalfilter;
Sorry, copy-pasted too fast. You can't use the date types in a string
without casting them.
sql='select orderdate, count(*) from orders where orderdate between '''
|| cast(mindate as char(11)) ||''' and '''||cast(maxdate as char(11)
||''' and '||additionalfilter;