I am having an Oracle database which is storing date as 'dd-Mon-yy', example date is 14-JAN-97 03.25.03 PM.

When I am getting this data from Hibernate I get date as- '14 January 2097'. How do I correct this?

Here is debug output: DEBUG - returning '14 January 2097' as column: CREATION8_10_0_

However if I execute the SELECT query against database then I get correct date: 14-JAN-97 03.25.03 PM.

Here is how my field is defined in Oracle-


And here is how it is mapped [mapping generated from Hibernate Tools],

I changed the type to 'timestamp' in mapping file, but it is still returning wrong date,

DEBUG - returning '2097-01-14 15:25:03' as column: CREATION8_10_0_

Hello,
date(s) are not stored like that but as numbers, usually like "long", what you see is just a representation, Hibernate is not converting it to a string but it's converted at some point after that, implicitly by a call to toString() by the logger/sysout/debugger (wathever you used to see those strings) or explicitly by some conversion that you have applied after receiving the Date instance from Hibernate.
Also make sure that the database and your server are using the same timezone, or they won't ever match ;-)

Change the creationDate type to String and add formula in property tag.

<property name="creationDate" type="string" formula="to_char(creationDate,'DD-MON-YY')">
<column name="CREATION_DATE" />
</property>

This will work.