timestamp issues

[scrupul0us]

when i retrive a timestamp from MySQL i get this format:

2006-03-02 07:47:00

where that is from:

$row["cdate"];

now.. if i go:

$unixdate = getdate($row["cdate"]);

and i print_r, i get:

rray ( [seconds] => 26 [minutes] => 33 [hours] => 19 [mday] => 31 [wday] => 3 [mon] => 12 [year] => 1969 [yday] => 364 [weekday] => Wednesday [month] => December [0] => 2006 )

which is wrong and therefore causes:

$mydate = $unixdate["mon"] ."/". $unixdate["mday"] ."/". $unixdate["0"] ." @ ".$unixdate["hours"].":".$unixdate["minutes"];

to display incorrectly...

any ideas?

[bpat1434]

What is the eventual goal? To get a unix timestamp? IF so, then just do:

$var = [man]strtotime/man;

Or, if you're just looking to format it:

$mydate = date("m/d/Y @ H:i", strtotime($row['cdate']));

Seems to work for me:
This thread's solution

[scrupul0us]

that format line worked awesome...

[bpat1434]

Great. Glad to hear it!!