Re: Inserting the current date

The now function will insert the current date and time:

insert into my_table( my_date_field ) values ( sysdate );

--Wes Sheldahl

"john" <servobit%www2(dot)us(dot)postgresql(dot)org(at)interlock(dot)lexmark(dot)com> on 12/08/2001
05:49:29 PM

To: pgsql-general%postgresql(dot)org(at)interlock(dot)lexmark(dot)com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] Inserting the current date

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