Re: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)

Bruce Momjian wrote:
> Floyd Shackelford wrote:
> >
> > The following bug has been logged online:
> >
> > Bug reference:      2997
> > Logged by:          Floyd Shackelford
> > Email address:      java2@fwshackelford.com
> > PostgreSQL version: 8.2.0
> > Operating system:   windows xp
> > Description:        parse error:
> > setObject("2004-August-15",java.sql.Types.DATE)
> > Details:
> >
> > jdbc: postgresql-8.2-504.jdbc3.jar
> >
> > this generates a number format exception:
> > preparedStatement.setObject(indx,"2004-August-15",java.sql.Types.DATE)
> >
> > this works:
> > preparedStatement.setObject(indx,"2004-08-15",java.sql.Types.DATE)
> >
> > i prefer to use the former.
>
> OK, but we only support the later.

Well to be specific, PostgreSQL supports both:

    test=> select '2004-August-15'::date;
        date
    ------------
     2004-08-15
    (1 row)

but jdbc only supports the later, so I suggest you contact the jdbc
maintaners.

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +