[support] support at drupal.org

[Cary Gordon]

Tashi Delek,


I guess the first question is, what is "the date import script"?

Without knowing anything about the site, I can tell you that I would not deal with figuring this out. if all the times are off by exactly two hours, I would dump the data table into a spreadsheet and correct the times. you need to do this in both the data table and the revision table

In Drupal 7, dates are stored like 2013-09-20 16:00:00, so obviously, any correction will need to deal with date boundaries.

There are lots of tools for manipulating the database. I use NaviCat.

Cary


On Aug 17, 2013, at 5:13 AM, Shérab <Sebastien.Hinderer at ens-lyon.org> wrote:

> Dear all,
> 
> Used the date import script tomove from event-style dates to the date
> module.
> The times displayed for the generated fields are incorrect and are
> shifted two behind the original event dates. I'm suspecting atimezone
> configuratonissue but can't figure out where the problem is.
> I tried several confiuration of the timezone handling pull-down in the
> date field, but this does not seem to make any difference. Personalised
> timezones is disabled on the site.
> An exemple of the issue can be seen here:
> http://www2.bodhicharya-france.fr/fr/node/914
> 
> Any help would be greatly appreciated.
> Thanks!
> Sherab.
> 
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]