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)
-
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...
-
float p_size = 0.1; default { state_entry() { llSay(0, "Hello, Avatar!"); llSetPrimitiveParams( [ PRIM_...
No comments:
Post a Comment