Re: [INTERFACES] Java and PGSQL date question

> I am trying to pass a date from Java into a PostgreSQL database. I am using
> the DateFormat.parse() funcitonality to format the date. However, the
> database doesn't want to take it? I looked at the PGSQL documentation and
> it says that the default date type is postgresql date type, which is: Wed
> Dec 17 07:37:16 1997 PST. Java is sending the date in this format: Wed Dec
> 17 07:37:16 PST 1997. How do I make this work. Is it easier to change the
> Java format or the PGSQL format?

postgres=> select 'Wed Dec 17 07:37:16 PST 1997'::datetime;
?column?
----------------------------
Wed Dec 17 15:37:16 1997 UTC
(1 row)

Looks good to me. Does this work from psql on your db? If so, then the
problem lies elsewhere...

- Tom

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California