Reformat XML 'date' output.

[eluser]Poccuo[/eluser]
If I have a DB row full of dates in this format:

2008-07-03
2008-06-01
2008-04-16

And I'd like to export them in XML in the following format:

07.03.08
06.01.08
04.16.08

I'm able to successfully export them in the former format via the following code:

Code:

$query = $this->db->query("SELECT date FROM news");
        
$config = array (
    'root'    => 'news',
    'element' => 'item',
    'newline' => "\n",
    'tab'    => "\t"
);

$data = $this->dbutil->xml_from_result($query, $config);
        
write_file("./data/news.xml", $data);

But I'm not sure what steps would be necessary to convert the query values to the format I desire.

Please help!

[eluser]gRoberts[/eluser]
using strtotime to parse the date, you could then output it using date to any format you wish...

[eluser]Poccuo[/eluser]
Thanks for your response. While it is true that this is one way to get the dates formatted, what I was not able to reason was how to save the newly formatted values back into the "$query" variable and then have them sent to the xml_from_result function.

My solution is as follows and relies on the MYSQL code to format the date for output. This is an awfully convenient solution to the problem.

Code:

$query = $this->db->query("SELECT DATE_FORMAT(date, '%m.%d.%y') as date_formatted FROM news ORDER BY date DESC");

$config = array (
    'root'    => 'news',
    'element' => 'item',
    'newline' => "\n",
    'tab'    => "\t"
);

$data = $this->dbutil->xml_from_result($query, $config);
write_file("./data/news.xml", $data);

Do you see any reason not to go this route?

For the sake of learning a little, could you show me how you'd take those formatted dates and store them back into the $query variable? I'm always up for learning something new!