Don't you think some sample data would help, as well as explanations about the required output?
Remember, none of us here know your data model.
In particular :
- what values are we to put in the leading <Interval> element?
- I don't recognize any date pattern in the following : <start>1301630400</start>
How do you convert a date to this number?
And your db version please? (select * from v$version)