date formation problems

From: "Ray Messier" <messier(at)nichewareinc(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: date formation problems
Date: 2000-02-19 17:18:51
Message-ID: NCBBJEKDMLKBHHEMCENNKEBACFAA.messier@nichewareinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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);

Attachment Content-Type Size
Ray Messier.vcf text/x-vcard 495 bytes

Browse pgsql-sql by date

  From Date Subject
Next Message Charles Mott 2000-02-19 19:53:40 Outer Joins
Previous Message Ray Messier 2000-02-19 17:14:07