Log in

View Full Version : Help with mysql query to change date of posts from a certan day


foundnyc
08-25-2009, 05:14 PM
Hi, My server clock was set 1 day fast, and when I changed it to be correct, all posts from yesterday show as being post tomorrow.

This has caused issues because all new posts(from today) appear before the posts from yesterday.

Im not really a programmer, but can someone help me with a mysql query that could search the dateline in the "post" table for posts from august 26 and change those to august 24th.

Marco van Herwaarden
08-28-2009, 09:34 AM
That won't work anymore as you by now already have "real" posts dating the 26th.