Re: [SQL] SYSDATE in PostgreSQL !?

2004-03-01 Thread Oliver Elphick
On Mon, 2004-03-01 at 21:18, Louie Kwan wrote: > 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 ? > CREATE TABLE channels( ... > updateTimeStamp DATE default (SYSDATE), > createTimeStamp D

[SQL] SYSDATE in PostgreSQL !?

2004-03-01 Thread Louie Kwan
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, sta