Inserting the current date

From: "john" <servobit(at)m(dot)r(dot)c>
To: pgsql-general(at)postgresql(dot)org
Subject: Inserting the current date
Date: 2001-12-08 22:49:29
Message-ID: ZNwQ7.642$CR2.230891@typhoon.maine.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a field (Date type) and I'd like to insert the current date and time.

e.g.:

insert into my_table( my_date_field ) values ( sysdate );

Is there an equivalent to Oracle's "sysdate" keyword?

Thanks,

John

Responses

Browse pgsql-general by date

  From Date Subject
Next Message john 2001-12-08 22:58:56 Re: Inserting the current date
Previous Message Brook Milligan 2001-12-08 21:17:40 Re: papers on datatype design