| 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