mcbootchek schrieb am 21.02.2005 16:12:

>
> I am just thinking there must be some smarter way how to get the date
> information only (not the time) from the timestamp then :
>
> SELECT
> (CAST (((extract (DAY FROM DATE))||'.'||(extract (MONTH FROM
> DATE))||'.'||(extract (YEAR FROM DATE))) AS DATE)) NEW_DATE
> ........
>
> I mean timestamp stored in the database is something like:
> 21.12.2004 08:45:56

Isn't

select cast(timestampfield as date) from...

just what you are looking for?
But I only tried that with a dialect 3-db, maybe dialect 1 behaves
differently...



Magnus