oracle mk sql

1 23:33:142013-03-09

select count(1) from eurusd t ;

delete from eurusd t where to_date(t.dates,'yyyy.MM.dd')>to_date('2011.12.31','yyyy.MM.

select t.dates,to_date(t.dates,'yyyy.MM.dd') from eurusd t ;

select count(1) from eurusd t where to_date(t.dates,'yyyy.MM.dd')>to_date('2011.12.31','yyyy.MM.dd');

 

 

posted on 2013-03-09 23:32  adolfmc  阅读(263)  评论(0编辑  收藏  举报