SYSDATE in PostgreSQL !?

From: Louie Kwan <lkwan(at)nuvo(dot)com>
To: "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org>
Subject: SYSDATE in PostgreSQL !?
Date: 2004-03-01 21:09:24
Message-ID: FB4FDC17A002D711BC0C009027DE84AF027F6BF2@EXCHANGE.nuvo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


How can I define a table with columns with sysdate as the default value..

If there is no SYSDATE defined in PostgreSQL , what can I do ?

Any help is appreciated.

CREATE TABLE channels (
channelID NUMBER PRIMARY KEY,
name VARCHAR2(64) NOT NULL,
status INTEGER NOT NULL,
remedyID VARCHAR2(15) UNIQUE,
remedySchemaID NUMBER default 48,
remedyLastModified INTEGER,
updateTimeStamp DATE default (SYSDATE),
createTimeStamp DATE default (SYSDATE)
);

Regards,
Louie Kwan

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bjoern Metzdorf 2004-03-01 21:16:28 Re: SYSDATE in PostgreSQL !?
Previous Message Tom Lane 2004-03-01 20:05:37 Re: Row data corruption under 7.3.5