删除某一BSC在某一时间段内的数据 

DELETE
FROM
    cdl_raw_do_12501_ztev8_sht_201509
WHERE
    call_start_time >= STR_TO_DATE(
        '2015-09-14 20:00:00',
        GET_FORMAT(DATETIME, 'ISO')
    )
AND call_start_time <= STR_TO_DATE(
    '2015-09-14 20:59:59',
    GET_FORMAT(DATETIME, 'ISO')
)
 and CDL_GEN_OID in ('ZZBSC2','ZZBSC3','ZZBSC5','ZZBSC7')

 

posted @ 2016-01-29 15:12  自由石匠  阅读(188)  评论(0)  编辑  收藏  举报