111111

[SubscriberNumber]=$1 AND [AcceptTime] between $2 and $3

<Variants>
<!--元素对应的变量的值-->
<Variant>
<ItemId>SubscriberNumber</ItemId>
<ItemName>服务号码</ItemName>
<VariantName>$1</VariantName>
<VariantValue>13912345678</VariantValue>
<DataType>VARCHAR2</DataType>
</ Variant >
< Variant >
<ItemId> AcceptTime </ItemId>
<ItemName>受理时间</ItemName>
<VariantName>$2</VariantName>
<!--<VariantValue>trunc(ExpectExecTime,'dd') -1 + 9/24</VariantValue>-->
<VariantValue> ExpectExecTime-86400 </VariantValue>
<DataType>Date</DataType>
</ Variant >
< Variant >
<ItemId>AcceptTime </ItemId>
<ItemName>受理时间</ItemName>
<VariantName>$3</VariantName>
<VariantValue> ExpectExecTime -1</VariantValue>
<Variantype>Date</VariantType>
</ Variant >
</Variants>