Kunal Lakhani wrote:Column in database is of 'Date' type.
can i make operations related to Date in database and while generating reports?
As far as the database columns are date, all Db operations meant for reporting should work.
Am thinking from a simple SQL point of view.
If your inserts are successful, and date information is available in the DB for your records, SQL that creates reports should work.
Also, if you use hibernate for generating reports, criteria/HQL should be able to read it .. for them its a date column in the DB.
The fetcher would not know how you inserted.
But.. if your POJO( entity class ) has a string for the value.. you'll have to handle the hassles of converting date in DB -> String in hibernate -> date to generate reports
I think hibernate will handle the first half of above.