On Mon, 1 Mar 2004, Bjoern Metzdorf wrote:
> Louie Kwan wrote:
>
> > If there is no SYSDATE defined in PostgreSQL , what can I do ?
> >
> > createTimeStamp DATE default (SYSDATE)
>
> Perhaps NOW() ist what you are looking for?
>
> createTimeStamp DATE default 'NOW()'
I don't think you want the quotes around now(), otherwise it will always
insert the same date / time each time.