Trouble with DATE_FORMAT

[kwdelre]

Hey guys. I've tried everything that I can find from searching but still cannot manage to get this to work.

 

I am simply running a SELECT query that is returning a 'date' field. I want to format this date as it is echoed. From all of the different examples I have seen I haven't seen the code in actual working code. Using the code below I get the date printed still but it is still in mysql's format. So here is the last attempt I made.

 

$QuizQuery = mysql_query("SELECT DATE_FORMAT('CURDATE()','%W, %M, %Y')
					 									Quiz_id, Score, Quiz_Name, Date_Taken, Pass
					 									FROM ".$QuizResultsTable." 
														WHERE User_id = '".$_SESSION['User_id']."' 
														AND Quiz_Name = 'P".$ii."' ");

 

I also tried using the DATE_FORMAT in the originating INSERT query with no result. Thanks for any help!

[Pikachu2000]

You aren't formatting the date coming from the database with that query, you're formatting a string with the value of 'CURDATE()' (which should be returning NULL).

 

$QuizQuery = mysql_query("SELECT DATE_FORMAT(`Date_Taken`, '%W, %M, %Y') as `formatted_date`,
                                              Quiz_id, Score, Quiz_Name, Pass
                                              FROM ".$QuizResultsTable."
                                             WHERE User_id = '".$_SESSION['User_id']."'
                                             AND Quiz_Name = 'P".$ii."' ");

 

After you run the query and fetch the (associative) array, the formatted date will be in the ['formatted_date'] index of the arrray.

[kwdelre]

Thank you sir! That worked!

[kwdelre]

I wanted to ask you about this syntax. Obviously I'm a beginner 

 

In your code response you used acentos around the original field name. In all examples from mysql.dev they use apostrophes. When I went to change your acentos to apostrophes (only to keep consistency) the date was NULL.

 

Does it have to be acentos? Just trying to learn it correctly, thanks for your explanation.

[Pikachu2000]

When enclosing a field or table name, it is done with the `backticks` (MySQL-specific),  whereas string values are enclosed in 'single quotes'. It normally isn't necessary to enclose field and table names unless it happens to be a MySQL reserved word.

[kwdelre]

Thanks a lot Pikachu. Go to know for the future.