> If it works for FB but not for IB, then you may have to take a

different

my mistake. it seems it doesn't work on either--it always returns
the time fraction. This seems to be different then Helen's
statements (page 153). The SQL:

select cast (Action_DateTime as date) from ActionLog

should just return the date and not the time.

Could someone confirm that I am doing it right but getting the wrong
results (which include the time fraction)?

Thanks
Ed Dressel