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>