date_time formatted query returning empty

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
maxd
Forum Commoner
Posts: 41
Joined: Sun Dec 04, 2005 12:12 am
Location: Denver

date_time formatted query returning empty

Post 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.
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Re: date_time formatted query returning empty

Post 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);
maxd
Forum Commoner
Posts: 41
Joined: Sun Dec 04, 2005 12:12 am
Location: Denver

Post 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!
Post Reply