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
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