| From: | Louie Kwan <lkwan(at)nuvo(dot)com> |
|---|---|
| To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | SYSDATE in PostgreSQL !? |
| Date: | 2004-03-01 21:18:15 |
| Message-ID: | FB4FDC17A002D711BC0C009027DE84AF027F6BF3@EXCHANGE.nuvo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Chaney | 2004-03-01 21:18:43 | Re: User defined types -- Social Security number... |
| Previous Message | Michael Chaney | 2004-03-01 21:12:31 | Re: User defined types -- Social Security number... |