Format datumu

mysql_query('SELECT DATE_FORMAT(datum, \'%e.%c.%Y\') datum from aktuality');

mysql_query("SELECT DATE_FORMAT(datum, \'%e.%c.%Y\') datum, menu FROM aktuality WHERE an = 'a' AND nazov != 'uvod' order by id desc");

$strQuery = "select DATE_FORMAT('DatePro','%e %c %Y') AS DatePro, Quantity from Factory_Output";

  $strQuery = "select  DatePro, Quantity from Factory_Output";

LEFT(DatePro, 10)

$strQuery = "select  LEFT(DatePro, 10), Quantity from Factory_Output";

  //$strXML will be used to store the entire XML document generated
    //Generate the chart element
    $strXML = "<chart caption='Factory Output report' subCaption='By Quantity' pieSliceDepth='30' showBorder='1' formatNumberScale='0'  animation=' " . $animateChart . "' showValues='0'>";
   
    // Fetch all factory records
    $strQuery = "select  LEFT(DatePro, 10), Quantity from Factory_Output";
    $result = mysql_query($strQuery) or die(mysql_error());
   
    //Iterate through each factory
    if ($result) {
        while($ors = mysql_fetch_array($result)) {
            //Generate <set label='..' value='..'/>     
            $strXML .= "<set label='" . $ors['DatePro'] . "' value='" . $ors['Quantity'] . "' />";
            //free the resultset
            mysql_free_result($result2);
        }
    }
    mysql_close($link);

    //Finally, close <chart> element
    $strXML .= "</chart>";
      
    //Set Proper output content-type
    header('Content-type: text/xml');
   
    //Just write out the XML data
    //NOTE THAT THIS PAGE DOESN'T CONTAIN ANY HTML TAG, WHATSOEVER
    echo $strXML;