Subject | RE: [IBO] Date issue ( again ) |
---|---|
Author | Ondrej Kelle |
Post date | 2001-03-12T07:55:46Z |
If SCDate is a timestamp field I think you should try
SELECT * FROM SalesCall WHERE CAST(SCDate AS DATE) >= :dSCFrom AND
CAST(SCDate AS DATE) <=:dSCTO
SELECT * FROM SalesCall WHERE CAST(SCDate AS DATE) >= :dSCFrom AND
CAST(SCDate AS DATE) <=:dSCTO