Oracle

Date 필드 Update

damian 2013. 12. 12. 14:57

alter session set nls_date_language='english';

alter session set NLS_DATE_FORMAT = 'YYYY-MM-DD HH:MI:SS PM';

 

update TN_SISS_COMTNWEBLOG

   set CONECT_DT = '2013-01-10  6:02:00 PM'

 where REQUST_ID = 'WEBLOG_0000000000001';