按照创建时间增量抽取,并将创建时间设置成yyyymmdd的形式
1.mysql
date_format(create_time, '%Y%m%d')=${thisday}
2.oracle
to_char(create_time,'yyyymmdd')=${thisday}
3.sqlserve
(convert(varchar(100),CONVERT(datetime, updateTime, 20),112)+0)=${bdp.system.bizdate}
4.mongo
"query": {
"bak_date": {
"$regex": "${yest}.*"
},
"type_country": "cyc_bx"
},