Hi,
Can i change the format of the date type ...


like when i use type="date" it generate the data type as date and when i save a particular date in my appilcation{new Date()},it save like 23-02-2009




I want the format like 23/02/2009

or 23 feb 2009


Can we change it?
if yes then reply plz...\if no then also reply plz..wkth d reason...thank u in advance

Which date format do you want to change? You mean the format in which the date field is stored in the DB? I dont think that can be changed. In DB dates are stored in its own internal format. For eg the number of milliseconds since the standard base time January 1, 1970, 00:00:00 GMT.

If what you mean is the format of the retrieved date then you can set that format by using:
alter session set nls_date_format='DD/MM/YYYY HH24:MI:SS'

Please tell exactly what you want to do and why you want that. Then may be we can figure out the solution.

hi litty,

actually the code is like this


<property name="dateOfExam" column="EXAM_DATE" type="date"/>


it store in database as

+------------
| EXAM_DATE
+------------
| 2009-03-02
+------------


i wantb

Exam_date as 2009/03/02 in database

n thank u very much

You said tht "it store in database as 2009-03-02". But this is not true. Coz as I said earlier the fields like date and timestamp are not stored as any formated String, but as numbers. Now when you query the DB you might be seeing the date field in the format YYYY-DD-MM. This is controlled by the NLS properties of your session which you can set by:
alter session set nls_date_format='DD/MM/YYYY HH24:MI:SS'

Do let me know if you are not clear.

hi litty,
can u tell me the exact procedure to set nls_date_format='DD/MM/YYYY HH24:MI:SS' in session...i m beginner ,i dont know how to set these properties..n thanks

Changing the date time format is different in different DB. In Oracle you can use Alter Session statement, mssql gets the date format from the windows date-time format settings etc.

For oracle using hibernate you can execute this sql by:


But I don't think this would be of any help to you. Coz what you get from hibernate for a datetype field is a java.util.Date object and the format of the date will be dependent on Locale. But you can use a java.text.SimpleDateFormat to format that Date object.

When you set display configuration options for dates, times, and numbers in the operating system, these settings affect the Date dialog box and other operating system windows. The Windows software you use also adopts those settings as you enter dates, times, and numbers (including currency) in your documents. This articles describes how to change the way Windows XP displays dates, times, currency values, and numbers.

But I don't think changing the OS date format for an application sake is a good approach. Well java has a good Locale api for handling that.

I think its application code responsibility to format how date type is displayed. There are thousands API for this purpose available. For example: org.apache.commons.lang.time.DateFormatUtils(date, "yyyy/MM/dd") ;