Received: from engine7.dnet.net.id (engine7.dnet.net.id [202.148.3.190]) by
	hub.org (8.8.8/8.7.5) with ESMTP id FAA27688 for
	<pgsql-sql@postgreSQL.org>; Wed, 8 Jul 1998 05:22:02 -0400 (EDT)
Received: from dnet.net.id ([202.148.1.18]) by engine7.dnet.net.id
	(post.office MTA v2.0 0813 ID# 0-13255) with ESMTP id AAA22316
	for <pgsql-sql@postgreSQL.org>; Wed, 8 Jul 1998 16:15:27 +0700
Sender: chai@.dnet.net.id
Message-ID: <35A33791.3D908698@dnet.net.id>
Date: Wed, 08 Jul 1998 16:10:41 +0700
From: Chairudin Sentosa Harjo <tsg@dnet.net.id>
X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.34 i586)
MIME-Version: 1.0
To: pgsql-sql@postgreSQL.org
Subject: Date
References: <3.0.1.32.19980626150540.006ab3dc@rr.pathlink.com>
	<3.0.1.32.19980626164554.006ac384@rr.pathlink.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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