Page 1 of 1

date_time formatted query returning empty

Posted: Fri Jan 12, 2007 6:22 pm
by maxd
I have a MySQL database, with a table including a datetime type field called "publishdate".

When I run this query:

Code: Select all

$releasesQuery = sprintf("select date_format(publishdate, '%a %D %b %Y') as formatted_date from newsreleases;");
I get "invalid query: Query was empty"

When I run it without the date_format:

Code: Select all

$releasesQuery = sprintf("select publishdate as formatted_date from newsreleases;");
It returns fine. But I'd like to take advantage of the date formatting capabilities of MySQL, rather than using a page-level function.

This is on a dedicated server my client set up. Is it possible something is wrong with the MySQL or PHP install?

I'm at a loss.

Re: date_time formatted query returning empty

Posted: Fri Jan 12, 2007 7:51 pm
by volka
maxd wrote:When I run this query:

Code: Select all

$releasesQuery = sprintf("select date_format(publishdate, '%a %D %b %Y') as formatted_date from newsreleases;");
I get "invalid query: Query was empty"
Why do you use sprintf here? % has a special meaning for sprintf.
try

Code: Select all

$releasesQuery = "SELECT Date_Format(publishdate, '%a %D %b %Y') AS formatted_date FROM newsreleases";
$result = mysql_query($releasesQuery, $mysqlConn) or die(mysql_error().': '.$releasesQuery);

Posted: Fri Jan 12, 2007 8:09 pm
by maxd
That fixed it.

Thank you very much. I had no clue what was wrong. I certainly never would have looked at the sprintf aspect of it. I'll have to research that syntax to avoid future blunders.

Vielen Dank!