date formation problems - Mailing list pgsql-sql

From Ray Messier
Subject date formation problems
Date
Msg-id NCBBJEKDMLKBHHEMCENNKEBACFAA.messier@nichewareinc.com
Whole thread Raw
List 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

pgsql-sql by date:

Previous
From: "Ray Messier"
Date:
Subject:
Next
From: Charles Mott
Date:
Subject: Outer Joins