Date

From: Chairudin Sentosa Harjo <tsg(at)dnet(dot)net(dot)id>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Date
Date: 1998-07-08 09:10:41
Message-ID: 35A33791.3D908698@dnet.net.id
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I need help with date.

create table blah
(
custnum int,
startdate date,
enddate date
);

How do I get the "real date" to insert to startdate when
the data is entered?

insert into blah
(custnum, startdate, enddate)
values
(001,???,'NULL');

I need a way to fill in the '???' field.
In oracle I could use
select sysdate from dual;

Regards
Chai

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1998-07-08 09:52:38 Re: [SQL] Date
Previous Message BD Postgres 1998-07-06 14:28:41 Re: [SQL] sql date functions