I tried to display the sqlcommand
after I saved into the database. Everything seemed to work pretty fine, but when I opened my table from TOAD, the dates are wrong.
Here is my sql command:
INSERT INTO USERTASK (USERTASKKEY, USERID, TASKKEY, TASKDATE, CREATEDATE, CREATEUSERID)
VALUES (USERTASKSEQUENCE.NEXTVAL, 'admin2', '1',
TO_DATE('05-06-2015','yyyy/mm/dd HH24:MI:SS'),
TO_DATE('2015-06-16 15:39:42', 'yyyy/mm/dd HH24:MI:SS'), 'admin')
In my database the date save as:
6/20/0016 3:00:00.000000
Here you can see a screenshot with several dates wrong:
What am I doing wrong?