X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 74CAED1B1F8 for ; Mon, 5 Jul 2004 05:23:12 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58992-10 for ; Mon, 5 Jul 2004 08:23:08 +0000 (GMT) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id 8627AD1B1BE for ; Mon, 5 Jul 2004 05:23:03 -0300 (ADT) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.27 (built May 12 2004)) id <0I0D00A01DKUGM@ndl1mr1-a-fixed.sancharnet.in> (original mail from sank89@sancharnet.in) for pgsql-php@postgresql.org; Mon, 05 Jul 2004 13:52:52 +0530 (IST) Received: from [61.0.94.203] by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.27 (built May 12 2004)) with ESMTPA id <0I0D00JYMDXZ1P@ndl1mr1-a-fixed.sancharnet.in>; Mon, 05 Jul 2004 13:52:49 +0530 (IST) Date: Mon, 05 Jul 2004 13:43:02 +0530 From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]" Subject: Re: Bad date external representation In-reply-to: <1089014787.23599.31.camel@Falcon> To: "Elijah O. Alcantara" Cc: pgsql-php@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <40E90D8E.4070707@sancharnet.in> Organization: Sai Hertz And Control Systems Pvt Ltd MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626) References: <1089014787.23599.31.camel@Falcon> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200407/2 X-Sequence-Number: 2827 Dear Elijah , >Code: > > >>$query = "Select date_created from organizationinfo where ctrl_no = >>'$ctrl_no'"; >>$date_created = pg_Exec($connectGovPH, $query); >> >>$query = "Select date_modified from organizationinfo where ctrl_no = >>'$ctrl_no'"; >>$date_modified = pg_Exec($connectGovPH, $query); >> >> fetch results by pg_fetch_result and then insert the data >>$query = "Insert into temp_organizationinfo >>VALUES('$ctrl_no','$organization_name','$domain_name','$loginID','$loginPassword','$date_created','$date_modified',4)"; >>pg_Exec($connectGovPH, $query); >> >> -- Best Regards, Vishal Kashyap Director / Lead Software Developer, Sai Hertz And Control Systems Pvt Ltd, http://www.saihertz.com Yahoo IM: coeb_college[ a t ]yahoo.com