cleartext.blogspot.com
<quer:projection id="idEEO2bDisabledPersonAnswerNo" alias="CorrectedStartDate">
<!--quer:customFunction name="TO_CHAR"-->
<quer:query projectedClass="Location" alias="Corr_Start_Dt">
<quer:projections>
<quer:projection>
<quer:add>
<quer:field ownerQuery="MainQuery" path="Applications,Offers,ActualStartDate"/>cleartext.blogspot.com
<quer:divide>
<quer:add>
<quer:field path="NetworkLocation,TimeZone,Offset"/>
<quer:multiply>
<!---->
<quer:add>
<quer:customFunction name="TO_NUMBER">
<quer:customFunction name="SUBSTR">
<quer:customFunction name="TZ_OFFSET">
<quer:customFunction name="TO_CHAR">
<quer:field ownerQuery="MainQuery" path="Applications,Offers,ActualStartDate"/>
<quer:string>TZR</quer:string>
</quer:customFunction>
</quer:customFunction>
<quer:integer>1</quer:integer>
<quer:integer>3</quer:integer>
</quer:customFunction>
</quer:customFunction>
<quer:divide>
<quer:customFunction name="TO_NUMBER">cleartext.blogspot.com
<quer:customFunction name="SUBSTR">
<quer:customFunction name="TZ_OFFSET">
<quer:customFunction name="TO_CHAR">
<quer:field ownerQuery="MainQuery" path="Applications,Offers,ActualStartDate"/>
<quer:string>TZR</quer:string>
</quer:customFunction>
</quer:customFunction>
<quer:integer>5</quer:integer>
<quer:integer>2</quer:integer>
</quer:customFunction>
</quer:customFunction>
<quer:integer>60</quer:integer>cleartext.blogspot.com
</quer:divide>
</quer:add>
<quer:integer>-1</quer:integer>
<!---->
</quer:multiply>
</quer:add>
<quer:integer>24</quer:integer>
</quer:divide>
</quer:add>
</quer:projection>
</quer:projections>
<quer:filterings>
<quer:filtering>
<quer:equal>
<quer:field path="Code"/>cleartext.blogspot.com
<quer:field ownerQuery="MainQuery" path="Applications,Requisition,JobInformation,PrimaryLocation,Location.Code"/>
</quer:equal>
</quer:filtering>
</quer:filterings>
</quer:query>
<!--quer:string>yyyy-MM-dd hh:mm:ss</quer:string></quer:customFunction-->
</quer:projection>
cleartext.blogspot.com
