---TIMESTAMP/DATE字段更新为当前时间,无论是TIMESTAMP/DATE,都可以设置为sysdate和systimestamp
--TIMESTAMP字段"12530_trk_time":
update "CMS_USER"."12530_track"
set CMS_USER."12530_track"."12530_trk_time"=systimestamp
where CMS_USER."12530_track"."12530_trk_songid"='889625'
update "CMS_USER"."12530_track"
set CMS_USER."12530_track"."12530_trk_time"=sysdate
where CMS_USER."12530_track"."12530_trk_songid"='889625'
--DATE字段"12530_ring_validate":
update "CMS_USER"."12530_track"
set
CMS_USER."12530_track"."12530_ring_validate"=systimestamp
where CMS_USER."12530_track"."12530_trk_songid"='889625'
update "CMS_USER"."12530_track"
set CMS_USER."12530_track"."12530_ring_validate"=sysdate
where CMS_USER."12530_track"."12530_trk_songid"='889625'
--TIMESTAMP字段"12530_trk_time":
--to_date('2009-04-29',
'yyyy-mm-dd')
update "CMS_USER"."12530_track"
set
CMS_USER."12530_track"."12530_trk_time"=to_date('2009-04-29',
'yyyy-mm-dd')
where CMS_USER."12530_track"."12530_trk_songid"='889625'
update "CMS_USER"."12530_track"
set CMS_USER."12530_track"."12530_trk_time"=to_date('2010-04-29
23:23:03', 'yyyy-mm-dd hh24:mi:ss')
where CMS_USER."12530_track"."12530_trk_songid"='889625'
--精确到分秒
to_date('2008/10/30 23:00:00',
'YYYY/MM/DD HH24:MI:SS')
update "CMS_USER"."12530_track"
set
CMS_USER."12530_track"."12530_trk_time"=to_timestamp('1995-04-29',
'yyyy-mm-dd')
where CMS_USER."12530_track"."12530_trk_songid"='889625'
update "CMS_USER"."12530_track"
set
CMS_USER."12530_track"."12530_trk_time"=to_timestamp('1996-04-29
23:23:03', 'yyyy-mm-dd hh24:mi:ss')
where CMS_USER."12530_track"."12530_trk_songid"='889625'
--DATE字段"12530_ring_validate":
update "CMS_USER"."12530_track"
set
CMS_USER."12530_track"."12530_ring_validate"=to_date('2009-04-29',
'yyyy-mm-dd')
where CMS_USER."12530_track"."12530_trk_songid"='889625'
update "CMS_USER"."12530_track"
set
CMS_USER."12530_track"."12530_ring_validate"=to_date('2010-04-29
23:23:03', 'yyyy-mm-dd hh24:mi:ss')
where CMS_USER."12530_track"."12530_trk_songid"='889625'
--精确到分秒
to_date('2008/10/30 23:00:00',
'YYYY/MM/DD HH24:MI:SS')
update "CMS_USER"."12530_track"
set
CMS_USER."12530_track"."12530_ring_validate"=to_timestamp('1995-04-29',
'yyyy-mm-dd')
where CMS_USER."12530_track"."12530_trk_songid"='889625'
update "CMS_USER"."12530_track"
set
CMS_USER."12530_track"."12530_ring_validate"=to_timestamp('1996-04-29
23:23:03', 'yyyy-mm-dd hh24:mi:ss')
where CMS_USER."12530_track"."12530_trk_songid"='889625'