I imported a few hundred entries successfully. These all had a unix timestamp in the entry_date field that was created from a typical mm-dd-yyyy type date field in excel. I’ve checked the unix timestamps against several online timestamp converters and they all show the correct date and day of the week, which is sunday. (All the entries should be on a sunday).
However, when I show the entries on the site, they all are 1 day behind, they show Saturday. I thought this might be a time zone issue, so I added 6, 8, 12, and 15 hours to the timestamps, again, checking them that they still represent sunday, but the EE page still shows saturdays.
Here is an example timestamp : 718200000 which is Sunday 10/04/1992 whether viewed in GMT or PST. I grabbed this timestamp directly out of the exp_weblog_titles table.
On the weblog page it is showing Oct 3, 1992.
Here is the code I am using to show the date:
{entry_date format="%F %j%S, %Y"}My EE time zone is set to PST, but even when I move it around the day/date is always shown as saturday. Other non-imported entries in the system are all showing correct dates.
Any ideas?