[SOLVED] Date Format

[bravo14]

Hi all

 

The date format in the mysql database is yyyy-mm-dd and I want to display the date dd-mmm-yyyy

 

I have tried using the following code after having a look at other sites

 

echo ('<tr><td>'.$row[Date].(j-M-Y)'</td><td><b>Yardley</b></td>');

and I am getting the following error

 

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/fhlinux147/y/yardleyheroes.co.uk/user/htdocs/fixtures.php on line 59

 

Can anyone give me any pointers

[DarkWater]

1) You need to use the DATE_FORMAT() MySQL function on your query.  What type is the column in the DB?

 

2) Use ' ' around your array keys please...

[br0ken]

Is this what you want?

 

<?php

echo "<tr><td>".date("j-M-Y", $row[Date])."</td><td><b>Yardley</b></td>";

?>

[DarkWater]

date() expects a timestamp, br0ken.

[br0ken]

date() expects a timestamp, br0ken.

 

I assumed he'd stored a timestamp in the database and that's what he was retrieving...

[DarkWater]

"The date format in the mysql database is yyyy-mm-dd..."

 

=X  I think he used a DATE or DATETIME.  It would be helpful if he posted.

[Barand]

... and the required format is "dd-mmm-yyyy", not "d-mmm-yyyy".

 

So

echo "<tr><td>".date("d-M-Y", strtotime($row['Date']))."</td><td><b>Yardley</b></td>";

 

@br0ken, When was "yyyy-mm-dd" a unix timestamp? No need to assume, read the first post, first sentence

[bravo14]

Sorry guys should have said the field is a date field not datetime does that make any difference to what I am trying to achieve?

[Barand]

Date field is fine.