calculating timestamps

[padanaram]

I have a mysql 3.23.58 server and php 4.2.2. I noticed that in mysql 3.23.58 when calculating a timestamp, lets say I am doing something like this in my sql.

select email from tbl_customer
where date_added < current_timestamp
and date_added > current_timestamp - 00000003000000;

The date added field is actually a field that holds a time stamp. The zeros with the three represents three days before the current time stamp.

If three days before the current time stamp is in a previous month, I noticed that in mysql 3.23.58 it subtracts the days from 100 when the 2 digits in the timestamp that represent the month go to the previous month. In mysql 5 and newer the timestamp will calculate correctly. Is there anything in php to calculate timestamps?

Greg

[Weedpacket]

First of all, MySQL timestamps aren't in the same Unix-style format as those used by PHP and other parts of the computing world. Maybe there's a difference in MySQL's format from one version to another. You'll have to check MySQL's documentation for that (which will also say how to convert MySQL timestamps into Unix-style) - certainly it has nothing to do with PHP.

In PHP (and using Unix timestamps) there are plenty of functions for manipulating timestamps and performing calculations with them, listed in the [man]DateTime[/man] section of the manual.

[padanaram]

I was looking through PHP Builder and found some stuff on usign the str to time function.

Greg