am using hibernate to store the data in to database. Oracle version is 10g. when i insert the date value in to Oracle Date field. its taking "dd/mm/yyyy" format. i want that to be "dd/mm/yyyy hh:mm:ss a" like "06/22/2006 11:24:34 PM". In the hibernate pojo field data type is java.sql.date.
i tried "new Timestamp(System.currentTimeMillis())", new Timestamp(new Date().getTime()) etc. please let me know the solution.
Nagaseshagiri, From Java's end of things, you can solve this problem by using a PreparedStatement. Then you just call prepStmt.setTimeStamp(timestamp) and don't have to worry about the format.
Thanks for your suggestion. Am using Hibernate with Spring which handles the Database operations. Please let me know if there is any other alternative from java end to set the timestamp as needed.
Thansk for the message. I even tried with the Hibernate mapping n when i changed the property value from "date" to sql timestamp, hibernate is throwing error : cannot find the matches for the type timestamp. I changed the Oracle data type to TIMESTAMP and i had new problem as time is stored as "mm/dd/yyyy 12:00:00:00,000 AM". Time is stored as default 12:00:00 AM and its not right. it is not taking the right time.