Re: SYSDATE in PostgreSQL !?

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Bjoern Metzdorf <bm(at)turtle-entertainment(dot)de>
Cc: Louie Kwan <lkwan(at)nuvo(dot)com>, "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: SYSDATE in PostgreSQL !?
Date: 2004-03-01 21:19:17
Message-ID: Pine.LNX.4.33.0403011418490.681-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Amit Kush 2004-03-01 23:00:49 Help! Regarding Pg for posgreSQL
Previous Message Bjoern Metzdorf 2004-03-01 21:16:28 Re: SYSDATE in PostgreSQL !?