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.us.postgresql.org@interlock.lexmark.com> on 12/08/2001
05:49:29 PM

To:   pgsql-general%postgresql.org@interlock.lexmark.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