Re: VBA ADO Command Date Parameter Not Working - Mailing list pgsql-odbc

On Mon, Nov 23, 2009 at 9:24 AM, Josh T <mortonjt@rochester.rr.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