Forum Moderators: open

Message Too Old, No Replies

increase date by one

         

ayushchd

8:17 am on Oct 25, 2007 (gmt 0)

10+ Year Member



Hi. In one of my tables, i m storing the date in a column whose datatype is int(14)
In this a Unix timestamp is being stored.
When I echo them using php date function, it shows :(distinct values)
14 july,
15 july,
16 july

I want to change all of them and make every 14 july : 15 july and every 15 july to 16 july and so on.

Please can someone help me?

Habtom

8:23 am on Oct 25, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



increase date by one

You can do the following:

UPDATE table1 SET datefield = datefield + 86400;

86400 equivalent to one day.

Warning: test first