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