On Mon, Nov 23, 2009 at 9:24 AM, Josh T <mortonjt(at)rochester(dot)rr(dot)com> wrote:
> cmd.Parameters.Append cmd.CreateParameter("@test_date", adDBDate,
> adParamInput, 4, "2009-11-23")
Does anything change is you set the byte size from 4 to something like 10 or 12?
> cmd.CommandText = "INSERT INTO test_table (test_date) VALUES (?);"
Another thought would be to rewrite the insert expression to:
INSERT INTO Test_table( test_date )
VALUES( CAST( ? AS DATE ));
Although it probably wont help much.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug