N V

N V

  • NA
  • 503
  • 2.6k

Inserting system full date & time problem in silverlight

Mar 7 2013 6:54 AM
can any one help me to solve this my problem regarding the fetching system full date & time 

`Insert into problem_register (problem_reg_srno,dpsrno,invsrno,problem_description,reporteddate)values
(seq_problem_reg_srno.NEXTVAL,'7','198 ',' mouse problem ',(select to_date(sysdate, 'mm-dd-yyyy hh24:mi:ss')from dual));`enter code here`

with using this query I only get date not system time


`Insert into problem_register (problem_reg_srno,dpsrno,invsrno,problem_description,reporteddate)values
(seq_problem_reg_srno.NEXTVAL,'7','198 ',' mouse problem ',(select to_char(sysdate, 'mm-dd-yyyy hh24:mi:ss')from dual));`enter code here`


this shows error like  


    ORA-01830: date format picture ends before converting entire input string