Problem using date_format() and CONVERT_TZ() together

[excelsior9]

Hi guys, I have this code on a page:

$query = "SELECT id,title,author,summary,published,subsection,frontpage,topstory,image1,postdate,date_format(CONVERT_TZ(postdate,'MDT','GMT'),'%d/%m/%y (%T)') AS readable_date FROM content WHERE section='News' ORDER BY postdate DESC";

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){


[....]
echo "</td>
<td class=\"normalcell\" style=\"width:140px;\">";
echo $row['readable_date'];
echo "</td>
}



Unfortunately the $row['readable_date']; echo is returning a complete blank space... any ideas why? It was working fine before I added convert_tz()

 

[johnwm]

1. Check out faq222-2244 to see how forum etiquette works. You appear to have asked 6 questions, said 0 thank yous, marked 0 answers as helpful and posted 0 replies to anyone else's questions.

2. Are the time zone information tables installed in your mysql database? See

http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html

for details

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints