업무/DB

[oracle] 날짜 집어넣기

랄프위검 2012. 4. 10. 18:00


INSERT INTO userfile(file_seq, fdate, filehosts)  VALUES('46', to_date('2011-07-15 08:26:54','YYYY-MM-DD HH24:MI:SS'), 'localhost');


 to_date('15/07/05 12','DD/MM/RR HH')