Resolved Date formatting

[Name]

I don't know if this is PHP or SQL formatting, so forgive me.

Problem:

  echo "<td>" . date('Y-m-d', $row['EntryDate']) . "</td>";

Result:

1969-12-31

Raw:

2012-04-22 21:55:01

Desired:

April 22, 2012

[Shane Mark]

From last many time i found date format for database finally i got that. Thank you...

[felgall]

Originally Posted by Name

Problem:

echo "<td>" . date('Y-m-d', $row['EntryDate']) . "</td>";

Solution

echo "<td>" . date('F j, Y', $row['EntryDate']) . "</td>";

[Name]

Originally Posted by felgall

Solution

echo "<td>" . date('F j, Y', $row['EntryDate']) . "</td>";

Result:

December 31, 1969

[abduraooft]

What do you get when you echo $row['EntryDate'] ?

[Name]

Originally Posted by abduraooft

what do you get when you echo $row['entrydate'] ?

2012-04-22 21:55:01

[felgall]

Oops - left out a small piece of the code:

echo "<td>" . date('F j, Y', DateTime($row['EntryDate'])) . "</td>";

You need to convert the text string returned to a date before you can format it.

[guelphdad]

why not format the date using DATE_FORMAT directly in your mysql query, then there is no need to do it at output in the php code.

[Name]

Originally Posted by guelphdad

why not format the date using DATE_FORMAT directly in your mysql query, then there is no need to do it at output in the php code.

I would like to keep the time of the entry, however format the result. Would it be better to have 2 fields? One for date. One for time?

[Name]

Originally Posted by felgall

Oops - left out a small piece of the code:

echo "<td>" . date('F j, Y', DateTime($row['EntryDate'])) . "</td>";

You need to convert the text string returned to a date before you can format it.

This broke the query and it doesn't show any data in the table.

[Name]

echo "<td>" . date('D M j, Y', strtotime($row['EntryDate'])) . "</td>";

Here is the solution. Was missing the strtotime function.

[guelphdad]

Perhaps you should look up DATE_FORMAT in the MySQL manual.

[Name]

Date() worked though?