Oracle修改及时间相关语法

update tablename t set t.QDSJ=null,t.PUSER='auto',t.LAST_MODIFY=to_date('2008-03-06 08:25:51','yyyy-mm-dd hh24:mi:ss') where t.XZ_ID=58 and t.STEWARD_ID=104

 

select a.DEPT_NAME 部门名,a.MEETING_NAME 会议名,a.LAST_MODIFY 修改时间,b.TIME1 开始时间,b.TIME2 结束时间,to_char(c.KSRQ,'yyyy-mm-dd') 开始日期,to_char(c.JSRQ,'yyyy-mm-dd') 结束日期,c.XZ 性质,b.XZ_ID XZID from t_meeting a,t_meeting_qd_time b,t_meeting_xz c where a.ID=c.MEETING_ID and b.XZ_ID=c.ID