help with timestamp - php

[Anon]

i'm storing a timestamp type column on a database. I don't know why, but every time I access the timestamp with date or getdate, the date is: 18/1/2038 , 22:14
This is supposed to be the farest date a linux pc can handle (is your pc 2039 compliant? eheheh), right?
The timestamps are stored correctly on the db, i think. Look at some php code and what it shows:
$row->tempo is the fetched column of the db
echo "Message written the ".$data[mday]."/".$data[mon]."/".$data[year]." at ".date("H:i", (int)$row->tempo)."
This should output 9/8/2001, 22:10. NO It outputs "18/1/2038 at 22:14".
Even when I fetch another row and the timestamp is different
So I tryied one last thing: I gave date a timestamp and i wanted it back(and confronted with the original timestamp):
echo "$row->tempo - ".date("U", $row->tempo);
this should output 2 equal numbers separated by a "-". NOOOOOO (????????????????) It outputs:
20010809211938 - 2147483647
See? the two numbers are different! Why? Am i giving an invalid timestamp? I'm inserting timestamps with time()! This should be the right timestamp! What's the mistake?

[toma42]

time() <> database.datetime || database.timestamp

What database are you using?

to set a timestamp in many databases, set it to null and it will be set to the current time.

To retrieve a timestamp you need to use your databases method of retrieving it as seconds since epoch. In mysql this is done by unix_timestamp(timestamp_column)

Tom

For more, check out http://www.ciwbootcamp.com. They teach this stuff all the time.

[Anon]

I found the mistake looking on php.net
Mysql timestamp is not compatible with PHP (same as system?) timestamp. So I altered tempo as a VARCHAR and i'm storing PHP timestamps as strings. It works.