Hi ,
Want to insert a sysdate with timestamp into a date field , as i can't able to change the existing structure nor the NLS format .
example : Create table d_cust (d_date date) ;
insert into d_cust select to_date(sysdate,'dd-mon-yyyy hh24:mi:ss') from dual
--still the output is date i,e 07/22/2016. Is there anyother alternative without changing the NLS format.