Hi again...
Hi,
When I felt proud because last week I had asked about how to
use NOW(), and
get answer that got me working, but now I have a strange
problem. It listing
dates, but it not listing like it should, when the web page
is create it
going 9, 8, 5, 10 on the dates. Here is
Your alias and column name are the same.
Which one do you think is being tested?
Also DATE is a reserved word.
Chuck \PUP\ Payne wrote:
Hi again...
When I felt proud because last week I had asked about how to use NOW(), and
get answer that got me working, but now I have a strange problem. It
»Chuck PUP Payne« sagte am 2002-04-10 um 10:27:19 -0400 :
going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using...
That's because your DATE which you've made with DATE_FORMAT is treated
as string. To fix it, I'd write:
SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title,