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)
-
LINK: http://www.techonthenet.com/oracle/functions/nvl.php Oracle/PLSQL: NVL Function In Oracle/PLSQL, the NVL function l...
-
Setting up a MPI cluster on Ubuntu involves the following steps: 1. Install OpenMPI on all machines. $sudo apt-get install libopenmpi-de...
-
Very Useful Link: http://people.cc.ku.edu/~grobe/intro-to-LSL/index.html#particle Using the Linden Script Language This page is a short...
No comments:
Post a Comment