Postgres Pro
Downloads
Home   >   mailing lists

How to solve invalid input for tyep timestamp problem? - Mailing list pgsql-jdbc

From Joost Kraaijeveld
Subject How to solve invalid input for tyep timestamp problem?
Date
Msg-id 1130929037.29028.22.camel@Panoramix
Whole thread Raw
Responses Re: How to solve invalid input for tyep timestamp problem?  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view 
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.Kraaijeveld@Askesis.nl
web: www.askesis.nl

pgsql-jdbc by date:

Previous
From: mani thiyagarajan
Date:
Subject: how to insert bulk of records dynmically?
Next
From: Dave Cramer
Date:
Subject: Re: How to solve invalid input for tyep timestamp problem?