RE: [Hsqldb-user] setTimestamp Vs setDate

[William K. <wk...@ei...>]

I don't know about specific database implementations but here's a link to a
useful page in the Java JDBC documentation that shows how SQL types map to
Java types and vice versa...

http://java.sun.com/j2se/1.4.1/docs/guide/jdbc/spec/jdbc-spec.frame8.html


...
Krick




-----Original Message-----
From: hsq...@li...
[mailto:hsq...@li...]On Behalf Of fredt
Sent: Thursday, September 26, 2002 8:39 AM
To: SB; hsq...@li...
Subject: Re: [Hsqldb-user] setTimestamp Vs setDate


I don't know of a comparative list of SQL types supported by different
databases. Our data types are as close to SQL standards as possible.

We will support the conversion from timestamp to data in the release version
of 1.7.1.

Fred Toussi

-------------

SB Wrote:

> You are obviously attempting to set a DATE column with a Timestamp value.
>

well, oracle's jdbc driver allows that - so I thought it might work
here too - as timestamp will have date.


> We may allow this conversion in the future but it is not currently
> supported.
>

Okay, I have changed my field type to datetime, but  is this a standard
datatype? Where can I get a list of datatypes that are supported by almost
all jdbc implementations?



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user