Updating oracle date fields
It does not add any "extra 12" to your date column.The only problem you have is with displaying the values.
Dear All I have to insert/update a date column while creating a new item, but the problem is i am able to insert/update only date but i need both date and time along with AM/PM. Date(); long date Long = Time(); stmt Date(33, new
By using these 3 lines i am able to insert/update only date. Date(date Long)); Below code retrives the date exactly what i need but unable to pass in the statement: Date Format formatter = new Simple Date Format("dd-MM-yyyy HH:mm:ss a"); Date(); String stringdate = formatter.format(d); String tmpdate = date Format(); stmt String(33, tmpdate); -- I tried with set Object as well but same error coming.
CHECK THE DATATYPE OF THIS TWO FIELDS AND THEN CHECK THE DATE FORMAT FOR THESE FIELDS. NOW USE THIS QUERY FOR UPDATE: UPDATE FACTORYORDER SET DUEDATE='30-JUL-2001' WHERE OLDDATE='06-JAN-2004'; NOTICE : ABOVE QUERY WILL UPDATE ALL THE RECORDS HAVING OLDDATE AS '06-JAN-2004'.
I have a date field in an Oracle table and I want to insert a new record.
Cause 1) There is only one user logged into the database.