Date - Mailing list pgsql-sql

From Chairudin Sentosa Harjo
Subject Date
Date
Msg-id 35A33791.3D908698@dnet.net.id
Whole thread Raw
In response to Re: [SQL] Date fields and libpq....  (Kachun Lee <kachun@pathlink.com>)
Responses Re: [SQL] Date  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List 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



pgsql-sql by date:

Previous
From: BD Postgres
Date:
Subject: Re: [SQL] sql date functions
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] Date