Cast from datetime to date does nothing

I am trying to cast datetime to date using the following

select log.lid, cast(log.ldate as date), log.clid, log.staid, log.emid
from tblclientlog_oes log

Resulting date comes back as datetime. Is firebird cast broken and cannot distinguish a difference between date and datetime? if so, what would be some other ways to do it.

I have no problem to convert datetime to date this way.
I tried both with IBExpert and with isql.
How did you tried it?

Firebird version 1.5.
IBexpert version 2005.06.07.

1/18/2008 7:43:07 AM

This is the resulting date after cast from datetime to date.

My version of Firebird is 2.1.3.
Have you try it with isql from command line?