AKC> This is exactly the place where using TIMESTAMP(=DateTime) type
AKC> fields still make things easier.

Sorry, that went out a bit too early... wanted to add the following:

see also "The Firebird Book" by Helen Borrie on page 153 and find help in CASTing, for example:


WHERE
CAST(D + T as TimeStamp) >= :pm_DateTimeMin
and
CAST(D + T as TimeStamp) <= :pm_DateTimeMax


Make sure you're using parameters when executing this type of statement frequently in short order on one connection.

---