Received: from hotmail.com (law-f164.hotmail.com [209.185.131.227]) by hub.org (8.9.3/8.9.3) with SMTP id DAA55416 for ; Tue, 25 May 1999 03:52:57 -0400 (EDT) (envelope-from anna_langer@hotmail.com) Received: (qmail 36057 invoked by uid 0); 25 May 1999 07:54:52 -0000 Message-ID: <19990525075452.36056.qmail@hotmail.com> Received: from 195.242.55.62 by www.hotmail.com with HTTP; Tue, 25 May 1999 00:54:52 PDT X-Originating-IP: [195.242.55.62] From: "Anna Langer" To: pgsql-interfaces@postgreSQL.org Subject: Questions about INSERT INTO! Date: Tue, 25 May 1999 00:54:52 PDT Mime-Version: 1.0 Content-type: text/plain; format=flowed; Hi! Thanks for all help. It worked very well. We still have some problems with inserting a datetime into the database. If we write like this the database accept it: PQexec(conn, "INSERT INTO test VALUES('23/01/1999 12:03:30'); When we are inserting other values in the database we write like this: sprintf(command, "INSERT INTO octets VALUES(%d, %d)", a, b); Now we wonder if we can put the date in to the database in the same way that we did with the integers? We have tried to make the date to a string, but it doesn't take it. The errormessage say that the database is of type datetime and the string is of type int4. Is there anyone who can help us with this? Thanks! Anna and Maria ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com