DATE_FORMAT Problems

[Nematoth]

I am currently building a project management system in PHP and MySQL but am having problems formatting the date correctly. As a test I have manually inserted values into a date column in one of my tables. Looks like this: 2002-12-19.

When I do this:

SELECT project_number, project_name, description, DATE_FORMAT('start_date', '%d/%m/%y') AS Start_date, completion_date, status FROM project;

The result returned in the Start_date columm is NULL....

Any ideas why this might be happening?

Cheers! Thomas Shearer
Multimedia Developer

http://www.pixelimage.co.uk

 

[sleipnir214]

start_date is a column name, not a string literal, right?

Don't put it in quotes in the date_format() function. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Nematoth]

I have just figured it out....doh!
Is there any way to remove these posts so I don't look totally dumb!!! haha...

I removed the '' wrapping the column name. i.e:

SELECT project_number, project_name, description, DATE_FORMAT(start_date, '%d/%m/%y') AS Date_started, completion_date, status FROM project;

Please remove this thread.... Thomas Shearer
Multimedia Developer

http://www.pixelimage.co.uk

 

[Nematoth]

Cheers Sleipnir...u got in there just b4 me! Thomas Shearer
Multimedia Developer

http://www.pixelimage.co.uk