Below is the scripts that inforces the correct format in the DB.
UPDATE
set DATE_Column
RRRR: Here enforces the Year to be four digit.
Friday 10 September 2010
Oracle: Inforcing Date Format ...
Sometime we can have a problem with the date format in Oracle DATE column. In this case i was having a problem that Java was not able to read the DATE properly.
Below is the scripts that inforces the correct format in the DB.
UPDATETABLE_NAME
set DATE_Column = TO_DATE ( DATE_Column, 'DD/MM/RRRR' )
RRRR: Here enforces the Year to be four digit.
Below is the scripts that inforces the correct format in the DB.
UPDATE
set DATE_Column
RRRR: Here enforces the Year to be four digit.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment