Simple help displaying date/time

[woodsonoversoul]

Hi all,

 

I'm trying to display a datetime type which I save with NOW()

 

ie:

    // create query
    $query = "INSERT INTO purchase (category, location, price, time) VALUES ('$category', '$location', '$price', NOW())";

 

time is a datetime type

 

I want to just display the "time" part of time,  not the date

 

this is the code I'm using:

echo "<li><a href=".$_SERVER['PHP_SELF']."?category=".$row[5].">".date("G.i:s", $row[5]."</li>";

 

and getting a "Parse error: syntax error, unexpected ';' ..."

 

any help with the error?

 

[cyber_ghost]

do you mean that the... 2007-09-08 12:45:23 as a time? and get the time out of it?

 

 

if does.. then try this code....

 

 

list($date1,time1) = explode(" ",$row[5]);

 

then have fun with $time1 = this is the time like 12:45:23.. i hope this can be help!

[woodsonoversoul]

Does that allow me to mess around with the format of $time1? (G.i:s)

[teng84]

echo date('G.i:s','2007-09-08 12:45:23' );

 

[cyber_ghost]

nope... on that code... you a are getting the second part of datetime format... divided by space in between them..

 

[woodsonoversoul]

Alright, I've changed the display code to:

 

echo "<li><a href=".$_SERVER['PHP_SELF']."?category=".$row[5].">".date("g:i a", $row[5])."</li>";

 

and that works fine, except the time is wrong  ???

 

The time it displays has no relation on the actual value in that field. wtf?

[woodsonoversoul]

The output of

date("m/d/y g:i a", $row[5])

 

is 12/31/69 6:33 pm