Re: SYSDATE in PostgreSQL !?

From: Bjoern Metzdorf <bm(at)turtle-entertainment(dot)de>
To: Louie Kwan <lkwan(at)nuvo(dot)com>
Cc: "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: SYSDATE in PostgreSQL !?
Date: 2004-03-01 21:16:28
Message-ID: 4043A82C.9090707@turtle-entertainment.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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()'

Regards,
Bjoern

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message scott.marlowe 2004-03-01 21:19:17 Re: SYSDATE in PostgreSQL !?
Previous Message Louie Kwan 2004-03-01 21:09:24 SYSDATE in PostgreSQL !?