[RESOLVED] 2007-09-09 13:15:19 into this: 09/09/2007

[hatching]

I tried using the date function:

date("d/m/Y",$row['time'])

but it's giving me the 1969 thing.

Here's the date format in the mysql column.

2007-09-09 13:15:19

Any help will be appreciated

[foyer]

I would just use

$year = substr($date, 0,4);
$mon = substr($date, 5,2);
$day = substr($date, 8,2);

echo "$day/$mon/$year";

[Weedpacket]

If it's a MySQL date/time column then use MySQL's functions for formatting dates and times.

Otherwise look up [man]strtotime[/man].

[NogDog]

As the Weed-man said, I'd probably do it in the SQL (see the DATE_FORMAT() function if using MySQL), but if you prefer to do it in the PHP code:

date("d/m/Y", strtotime($row['time']))