2

My site time zone setting under Admin>config>regional... is set to Chicago time.

My field date setting is set to use my site time zone.

My user account is set to Chicago, but when I look at the database, it is recording my time as a totally different time zone.

What am I missing? I really need to resolve an issue with Drupal resource-conflict module and the fact that my all-day events don't conflict with my hourly events. There is a topic here - https://www.drupal.org/node/2270533, but I can't seem to get my dates straitened out to even try it. Anyone offer some advice?

Improve this question
1

When entering data into the field, the data entered is assumed to be in the site's time zone. When the data is saved to the database, it is converted to UTC. When retrieved from the database, the data is converted to the Site's time zone for anonymous users or the User's time zone for logged in users when User-configurable time zones is enabled. More info https://www.drupal.org/node/767182

Improve this answer
1
  • Thanks for the reply! I have to set my field widget to "no time zone conversion" in order to address my primary issue which is the resource-conflict detection not working on all-day events. When I do that, it screws up my dates on my reservation calendar. Is there a work-around for that?
    – Rob Adams
    Feb 9 '17 at 5:18
1

This is normal and expected. When you look in the DB, the Date API contrib module saves them as UTC time.

Drupal then fetches your Unix time UTC value, and converts it to your time zone.

Improve this answer
2
  • Here is what shows up in my database for example when I look at phpmyadmin on the datetime. 2016-04-24 04:00:00
    – Rob Adams
    Feb 9 '17 at 5:29
  • @RobAdams forget what I said earlier. Looks like the Date API contrib module saves them like that.
    – No Sssweat
    Feb 9 '17 at 5:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.