Postgres Pro
Downloads
Home   >   mailing lists

Re: SYSDATE in PostgreSQL !? - Mailing list pgsql-admin

From Bjoern Metzdorf
Subject Re: SYSDATE in PostgreSQL !?
Date
Msg-id 4043A82C.9090707@turtle-entertainment.de
Whole thread Raw
In response to SYSDATE in PostgreSQL !?  (Louie Kwan <lkwan@nuvo.com>)
Responses Re: SYSDATE in PostgreSQL !?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Louie Kwan
Date:
Subject: SYSDATE in PostgreSQL !?
Next
From: "scott.marlowe"
Date:
Subject: Re: SYSDATE in PostgreSQL !?