format date

[kristof_v]

hi,

in the database i have date values in this format: m.d.Y (eg 10.10.2006)
now i want to show the date values in a table in the following format: D M j, Y

so i tried this:

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

but this gives the well-known Thu Jan 1, 1970 for every date value

how do I do this?

grtz

[Little_G]

Hi,

try:

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

Andrew

[kristof_v]

thx for your suggestion.
unfortunately it didn't do the trick :(

other suggestions?

grtz

[jatar_k]

split/explode the db date on .

then feed the values to mktime

then feed that through date