datediff()求两个日期间间隔的函数:datediff(大日期,小日期)
datediff(from_unixtime(unix_timestamp(b.partitiontime,'yyyyMMdd')) ,from_unixtime(unix_timestamp(a.partitiontime,'yyyyMMdd')))<=30
and datediff(from_unixtime(unix_timestamp(b.partitiontime,'yyyyMMdd')) ,from_unixtime(unix_timestamp(a.partitiontime,'yyyyMMdd')))>=0