date addition 1

[ftsw]

Allowed to vote once per year.I have an attribute in a table called ung_sur_date that is a timestamp(12) datatype.
I am using mysql database and php.
My code:
$oneDay = 86400;
echo&quot;seconds per day is $oneDay <br><br>&quot;;

$today = date( &quot;U&quot; );
echo&quot;today is $today<br> &quot;;
echo date( &quot;F d, Y&quot;, $today );
echo&quot;<br><br>&quot;;
this shows $today in seconds from 1-1-1970;and this is good to add $oneday + $today.

echo&quot;date user votes is $row[ung_sur_date]<br>&quot;;
this shows 021104201011.
echo date( &quot;F d, Y&quot;, $row[ung_sur_date]);this shows an incorrect date, not november 4,2002. I can not find a mysql datatype that gives the number of second past 1-1-1970.

I want to use for my date math
$oneyearfuture = ($row[ung_sur_date] + ( $oneDay * 365));

echo&quot;one year in future from date user voted is $oneyearfuture<br>&quot;;
echo date( &quot;F d, Y&quot;, $oneyearfuture);
This shows an incorrect date becaude I am adding 021104201011 to the number of seconds passed 1-1-1970; which does not appear to be giving the correct date.

Do you know a datatype for a mysql table that shows number of seconds past 1-1-1970. Do you know of an easy fix to my problem of adding one year to $row[ung_sur_date]?
Thank You.

 

[Lalli]

Check

http://www.mysql.com/doc/en/Column_types.html

for column types...
INT is good choice for storing seconds passed since 1970...

To add one year to TIMESTAMP-type, use ADDDATE or DATE_ADD (they are same) functions...(check

http://www.mysql.com/doc/en/Date_and_time_functions.html

for more information).

like:
UPDATE some_table set date_col = date_col + interval 1 year where user_id = XX

-Cursed