Date Problem!

Hi all:

I have a date problem!

The date field indise the mySQl page contains: 2002-07-23 12:49:54

When I run <?echo $i[7];?> I get: 20020723124954

BUT when I run <?echo date("D M-d-Y H:i:s",$i[7]);?>, I get: Mon Jan-18-2038 22:14:07
!!!!!!!

Please Help!

what do you want it to output as?

If you try this it makes a difference:

<?echo "$i[7]"; ?>

puts it out as a string!!

<?echo $i[7]; ?>

puts it out as a numeric value!!

I need the output to look like this🙁as an example)

Mon-Jan, 12, 2002 12:32:54

or anything like that

try this:

<?php

$date = "$i[7]";

$date2 = strtotime($date);

$format_date = date("D M-d-Y H:i:s",$date);

print "Date is: $format_date";