[SOLVED] Problem with date

[Cagecrawler]

I am trying to show a particular date which is stored in my database as a timestamp.  If I echo just the timestamp variable, i get the following:
2007-01-28 04:38:23

However, I put it into the date function like so:
date('j.n H:i',$transactions['time'])

This should display 28.1 23:38, but the timestamp isn't recognised and it displays it as if the timestamp was 0 (ie. 1.1.1970).  How can I get it to use the right timestamp?

[Jessica]

That's not a timestamp, that's a mysql datetime. to make it a timestamp, do strtotime($transactions['time']) - that will make it a timestamp.

[redarrow]

[code]
<?php

$time_wanted=$transactions['time'];
$result=strtotime($time_wanted);
echo " The correct time wanted is: $result";

?>
[/code]

[Cagecrawler]

It works, thanks.

I double checked and my database column type is timestamp, so why does it output a datetime?

[Jessica]

Are you using mysql? The manual explains this: http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html
"TIMESTAMP columns are displayed in the same format as DATETIME columns. In other words, the display width is fixed at 19 characters, and the format is YYYY-MM-DD HH:MM:SS."

[redarrow]

To get a good timestamp use a int then insert a timestamp with the statement time();

[Cagecrawler]

Yes I am using mysql, and that link explained it all.  Thanks.