Re: Dates rejected

Martijn van Oosterhout <kleptog@svana.org> schrieb:
> > create table tt_teste (datfis timestamp without time zone not null
> >  CHECK (datfis = trunc(datfis::timestamp without time zone)));
>
> What are you trying to do here? If you only want a date, why not just
> use a date type?

This is an other question ;-)


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°