groovy oracle数据库,groovy oracle date

There are lots of problems with Oracle DATE & TIMESTAMP and their

counterpart Java classes since they do not directly compare. DATE fields

in Oracle will give date & time where as TIMESTAMP gives you a bit more

information (down to millis I think). SQL92 says DATE is year, month &

day (which is why java.sql.Date only gives you this).

As Jon said you will be getting back an instance of java.sql.Date (the

metadata for this column will claim you'll be getting back a timestamp

but it lies; look up oracle.jdbc.V8Compatable for more information). The

only way to be 100% sure about what you're getting back is to ask for

the timestamp or change your Oracle fields from DATE to TIMESTAMP and

then you're more inline with how Java will deal with it.

Andy

P.S. If you do change the field data type you'll get back a

oracle.sql.TIMESTAMPZ object which is castable to a java.sql.Timestamp

Jon Carlson wrote:

> It