Received: from nichewareinc.com (IDENT:root@[63.78.34.254]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA39645 for ; Sat, 19 Feb 2000 12:20:56 -0500 (EST) (envelope-from messier@nichewareinc.com) Received: from delllaptop (adsl-63-195-149-143.dsl.scrm01.pacbell.net [63.195.149.143]) by nichewareinc.com (8.9.3/8.8.7) with ESMTP id JAA11093 for ; Sat, 19 Feb 2000 09:28:05 -0800 Reply-To: From: "Ray Messier" To: Subject: date formation problems Date: Sat, 19 Feb 2000 09:18:51 -0800 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_000A_01BF7ABA.561B5200" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 This is a multi-part message in MIME format. ------=_NextPart_000_000A_01BF7ABA.561B5200 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit i have a table .... create table foo ( dfield datetime ); when i do an insert the date always comes out as 1969! any ideas why? $cSQL = "INSERT INTO foo (dfield) VALUES ('" . date("m/d/Y h:m a","12/09/2001 02:15 am") . "')"; pg_exec($oConn, $cSQL); ------=_NextPart_000_000A_01BF7ABA.561B5200 Content-Type: text/x-vcard; name="Ray Messier.vcf" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="Ray Messier.vcf" BEGIN:VCARD VERSION:2.1 N:Messier;Ray FN:Ray Messier ORG:Nicheware, Inc. TITLE:V.P. of Engineering NOTE:ICQ =3D 1549641 TEL;WORK;VOICE:(916) 797-6700 TEL;WORK;VOICE:(888) 428-7246 TEL;CELL;VOICE:(916) 870-5441 TEL;WORK;FAX:(916) 797-6767 ADR;WORK:;;1803 Cirby Way Ste 2;Roseville;CA;95661;USA LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:1803 Cirby Way Ste = 2=3D0D=3D0ARoseville, CA 95661=3D0D=3D0AUSA URL: URL:http://www.nichewareinc.com EMAIL;PREF;INTERNET:rmessier@unicom-inc.com REV:19990923T202834Z END:VCARD ------=_NextPart_000_000A_01BF7ABA.561B5200--