--- In firebird-support@yahoogroups.com, "Ed Dressel" <Dressel@A...>
wrote:

>
> > 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

What about:

SELECT (extract(day from TABLE.TIMESTAMP) ||'.'|| extract(month from
TABLE.TIMESTAMP) ||'.'|| extract(year from TABLE.TIMESTAMP)) as date

Petr