Currently I have a couple of date fields in my java objects that are mapped to equivalent date columns in Oracle database. Whenever, I read the dates, I always have to parse them and again reformat into the date format I need and it contains the time stamp 00:00:00 which I have to remove every time.

Is there an attribute like an sql-type or any other attribute that we can mention up front in the mapping file itself to read the date as is?

-Cheers
Rama

Try with 'date' as column type in hibernate mapping. It returns only Date (with out time) for your column/property.

http://forum.hibernate.org/viewtopic.ph ... highlight=

Hey thanks for the reply. I will try putting type="Date" in the mapping for every mapping of the date field and date column. I also realized that we anyways always have to parse :( the date whenever it is read before it is displayed or used anywhere.

Is it also possible to specify the formatting in the mapping file itself. We need the date format to be in the MM-dd-YYYY format rather than the oracle dd-MMM-YYYY format. Any suggestions?

You can not dictate the date format in Oracle form Hibernate. You have to format the date as per your wish.

Thanks

Oh ok. Looks like we have to get things done the hard way.

Thank you for your help.