How to solve invalid input for tyep timestamp problem?

From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: How to solve invalid input for tyep timestamp problem?
Date: 2005-11-02 10:57:17
Message-ID: 1130929037.29028.22.camel@Panoramix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I want log4j to log in a PostgreSQL database. Log34j uses "2005-11-02
11:49:57,844" as it's timestamp format. I used TIMESTAMP as a columntype
but apparenty that is not the correct type:

java.sql.SQLException: ERROR: invalid input syntax for type timestamp:
"2005-11-02 11:49:57,844"

What should be the type I should use for the column?

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2005-11-02 12:19:45 Re: How to solve invalid input for tyep timestamp problem?
Previous Message mani thiyagarajan 2005-11-02 07:17:35 how to insert bulk of records dynmically?