Re: Inserting the current date - Mailing list pgsql-general

From Jason Earl
Subject Re: Inserting the current date
Date
Msg-id 87bsh7c6rr.fsf@npa01zz001.simplot.com
Whole thread Raw
In response to Inserting the current date  ("john" <servobit@m.r.c>)
List pgsql-general
What exactly does sysdate do?  Is it anything like CURRENT_TIME,
CURRENT_DATE, or now()?

Jason

"john" <servobit@www2.us.postgresql.org> writes:

> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

pgsql-general by date:

Previous
From: Troy.Campano@LibertyMutual.com
Date:
Subject: Please ignore - test
Next
From: "Tim Nelson"
Date:
Subject: ecpg - select * into structure problem