On occasion you need to export the current date/time for one reason or another. This is how you get it out of the export:
<quer:projection alias="CurrentDateTime" xmlns:quer="http://www.taleo.com/ws/integration/query"> <quer:customFunction name="TO_CHAR"> <quer:date type="now"/> <quer:string>yyyy-MM-dd</quer:string> </quer:customFunction> </quer:projection> [
One of the big questions that’s asked of us in the computer field is how long is it going to take? I cringe when asked for dates in situations like this as the true answer is it will be completed when it’s completed. Computer programing is part (mostly) science but there is an art to it also. And to have the first without the last is to have something that works but doesn’t flow.
In any case my rough estimate on export of attachments out of the Oracle Taleo production zone is 74,848 attachments in a 24 hour period that in total are 10.26 GB in size. This is an extremely rough estimate and your mileage will certainly vary.
