From: Chairudin Sentosa Harjo <tsg@dnet.net.id>
To: pgsql-sql@postgreSQL.org
Subject: Date
Date: Wed, 08 Jul 1998 16:10:41 +0700
Message-ID: <35A33791.3D908698@dnet.net.id> (raw)
References: <3.0.1.32.19980626150540.006ab3dc@rr.pathlink.com>
<3.0.1.32.19980626164554.006ac384@rr.pathlink.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tsg@dnet.net.id
Subject: Re: Date
In-Reply-To: <35A33791.3D908698@dnet.net.id>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox