摘要：
export TIMESTAMP=`date +%Y%m%d_%H%M%S`GDGFILE=file1_${TIMESTAMP}.txtsuffix=${GDGFILE#*_}prefix=${suffix%%_*}echo $prefixCURRENT=`date -d -7day +%Y%m%d 阅读全文
摘要：
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') select * from tablename where time>= to_date('2011-05-02','yyyy-mm-dd') select * from tablename where 阅读全文