Re: TIMESTAMP

From: David Siebert <glwatcdr(at)yahoo(dot)com>
To: Barry Lind <barry(at)xythos(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: TIMESTAMP
Date: 2001-10-02 19:09:06
Message-ID: 20011002190906.22166.qmail@web11706.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

It looks as if I blew it when I cut and pasted it.
Lets try again.
This is the error message.

Phone Call PhoneCall(Rs) en:0 Bad Timestamp Format at
19 in 2001-10-01 15:20:06.66-05

and this is the method that generates it.

public PhoneCall(ResultSet rs) {
int errori=0;
try {
m_sCaller=rs.getString("scaller");
m_sPhone=rs.getString("sphone");
m_sPhone2=rs.getString("sphone2");
m_sQuedBy=rs.getString("squedby");
m_iPri=rs.getInt("ipri");
m_iStatus=rs.getInt("istatus");
m_sFor=rs.getString("sfor");
m_sNotes= rs.getString("snotes");
m_objPlacedDate =
rs.getTimestamp("dplaceddate");
errori++;
m_objTakenDate =
rs.getTimestamp("dtakendate");
errori++;
m_objResDate =
rs.getTimestamp("dresdate");
errori++;
m_iResolution = rs.getInt("iresolution");
m_iReQues = rs.getInt("ireques");
} catch (Exception ex){
System.err.println("Phone Call
PhoneCall(Rs) en:"+errori+" "+ex.toString());
}
}

__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2001-10-02 19:42:54 Re: driver fails to handle strings in query statements properly
Previous Message Dave Cramer 2001-10-02 18:03:03 Re: why would an update only work if done twice?