insert into table foo values ( date(now() ) ;
( you may change date format using set command )
>From: Peter Landis <ntwebdeveloper@yahoo.com>
>To: pgsql-general@postgreSQL.org
>Subject: [GENERAL] Date insert in table?
>Date: Mon, 21 Feb 2000 08:39:35 -0800 (PST)
>
>
> I have a problem to insert system date (current date)
>into a table in postgresql database.
>
>Unlike Oracle,it can not insert. Why is the length for
>"date" type only 4 (the format in Oracle should be
>YYYY-MM-DD)? How would you insert a date in the
>postgresql table? I am very appreciated if you could
>give me a reply.
>
>thanks
>__________________________________________________
>Do You Yahoo!?
>Talk to your friends online with Yahoo! Messenger.
>http://im.yahoo.com
>
>************
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
