Thursday, 19 September 2013

Inserting date from java to Oracle DB

Inserting date from java to Oracle DB

i was trying to insert a value to one of the column with DATE datatype in
Oracle DB through java.
Tried with the below insertSurveyQuery.append("cast(to_date('12/31/8888',
'MM/dd/yyyy' )as date), ");
OP in Oracle DB:
DEC-31-88
but i want the date to be stored like 12/31/8888.
Any of your help is appreciated!
-Thanks!

No comments:

Post a Comment