Support java.sql.Timestamp ???

Hi, Can any one please tell me if Informix supports the java.sql.Timestamp objects. So can Informix handle colomns of type timestamp, or should I just use the date type to accomplish this. I need to find a database which allows: PreparedStatement pstmt = ....... Timestamp ts = ..... pstmt.setTimestamp(1,ts) and Resultset rs = .... rs.getTimestamp(...) Is this possible whithin Informix ?? Thanks in advance, Raymond Domingo Blue Point

Yes, you need an Informix9 to do it. Nona >Subject: Support java.sql.Timestamp ??? >From: Raymond Domingo raymond_domingo@bluepoint.nl >Date: 13.03.00 12:13 W. Europe Standard Time >Message-id: <38CCCD68.D11531CB@bluepoint.nl> > >This is a multi-part message in MIME format. >--------------9035939CF8F5F0E9882459AE >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >Hi, >Can any one please tell me if Informix supports the java.sql.Timestamp >objects. > >So can Informix handle colomns of type timestamp, or should I just use >the date type to accomplish this. > >I need to find a database which allows: > PreparedStatement pstmt = ....... > Timestamp ts = ..... > pstmt.setTimestamp(1,ts) >and > Resultset rs = .... > rs.getTimestamp(...) > >Is this possible whithin Informix ?? > >Thanks in advance, >Raymond Domingo >Blue Point > >--------------9035939CF8F5F0E9882459AE >Content-Type: text/x-vcard; charset=us-ascii; > name="raymond_domingo.vcf" >Content-Transfer-Encoding: 7bit >Content-Description: Card for Raymond Domingo >Content-Disposition: attachment; > filename="raymond_domingo.vcf" > >begin:vcard >n:Domingo;Raymond >tel;fax:074 250 15 09 >tel;work:074 250 60 00 >x-mozilla-html:FALSE >adr:;;;;;; >version:2.1 >email;internet:raymond_domingo@bluepoint.nl >fn:Raymond Domingo >end:vcard > >--------------9035939CF8F5F0E9882459AE--