Re: Strange behaviour with date fields

Hi,

thanks for the help, it got me on the right path.

> There are two ways to solve your problem I guess:
> a) trunc(stamp) = to_date('01.02.1999', 'dd.mm.yyyy')
> I'm not sure if trunc needs a nother parameter to specify the position of
> truncation

Actually the round function has to be used:

round(stamp) = to_date('01.02.1999', 'dd.mm.yyyy')

Now it works

Thanks

    Clemens Received on Thu Apr 15 1999 - 06:54:02 CDT