Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1A0F547675D for ; Wed, 22 Jan 2003 14:30:08 -0500 (EST) Received: from smtp.wanadoo.es (unknown [62.37.236.142]) by postgresql.org (Postfix) with ESMTP id 2524D477118 for ; Wed, 22 Jan 2003 13:57:37 -0500 (EST) Received: from there ([80.103.154.191]) by smtp.wanadoo.es (8.11.6/8.11.6) with SMTP id h0N1ofh20670 for ; Thu, 23 Jan 2003 02:50:47 +0100 Message-Id: <200301230150.h0N1ofh20670@smtp.wanadoo.es> Content-Type: text/plain; charset="iso-8859-1" From: Jesus Rios To: "POSTGRESLQ-PHP" Subject: Date type: DATE Date: Wed, 22 Jan 2003 19:59:15 +0100 X-Mailer: KMail [version 1.3.2] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/48 X-Sequence-Number: 1793 Hi everybody. I've got a form where I ask for the date.I store the date in 3 variables: for the day i have $day (dd), for the month i have $month (mm) and for the year $year (yyyy). At the same time i have a table which is as it follows: Table "s_objetivos_caso" Column | Type | Modifiers -----------------+---------+----------- dni | integer | not null fecha | date | not null cod_s_objetivos | integer | not null How do i have to insert the column date?. $date="$year-$month-$day"; insert into s_objetivos_caso values ($dni,$date,$cod_s_objetivos,$conn); Can anyboy help me for how a i must format the date for introduce into the table??? Thank you. And sorry with my English.