I am trying to insert the timestamp into a table with today's date and time. My query is like this.
INSERT INTO EVENT_QUE (TRANSITION_TIMESTAMP) VALUES (TO_DATE(SYSDATE, 'DD-MM-YYYY HH24:MIS'))
Some how it is inserting the time like this 26 June 0003 00:00:00 for all the times of that day. How can I insert in the format I want with the correct time?