Page 1 of 1

date_format help

Posted: Sun Nov 20, 2005 10:26 am
by will83
Hi,

I am trying to pull dates out of a table and convert them to a different format.

However it's not working:

Code: Select all

$query = mysql_query("SELECT link_log.date_format(date,'%W, %M %D, %Y.') 
FROM link_log INNER JOIN link_company ON  link_log.company_id = link_company.id 
WHERE 1") or exit(mysql_error());

It is simply outputing nothing.

Do you think that it's not working becase it is in a join select?

Thanks

Will

Posted: Sun Nov 20, 2005 10:41 am
by will83
In answer to myself:

Code: Select all

$query = mysql_query("SELECT date_format(link_log.date,'%W, %M %D, %Y.') 
FROM link_log INNER JOIN link_company ON  link_log.company_id = link_company.id 
WHERE 1") or exit(mysql_error());
thanks me