java.sql.Date normalization problem

[Former Member]

Hi ,

I am trying to select a date from database . The data is fetched based on the record..

In the query when i pick records based on date , i get the following error..

"The object of type java.sql.Date with the value '2002-01-01 00:11:00.0' assigned to host variable 1 is not normalized. It must not contain time components in the time zone running the virtual machine."

the setHours,seconds.. etc seem to be deprecated. Could anyone suggest me an alternative method to normalize the date.

Your help is greatly appreciated

Thanks and Regards

Bharathwaj.

[Former Member]

Take "Timestamp" datatype and try it.

[Former Member]

Used Calendar Object for conversions !