Thread

Would someone please explain the technical details behind what’s suppose to happen with the Expiration Date field on channel entries?

Is the date that I choose the date for my current timezone or do I has the user need to add my offset when selecting a time?

How would an individual’s localization settings affect Expiration Date?

Is the timestamp in the database suppose to be UTC?  When I pull expiration_date out of channel_titles, what am I suppose to be getting?

How do my date/time-related config settings affect all of this?

$config['daylight_savings'] = date('I') ? 'y' : 'n';
    $config['server_timezone'] = 'UM5';

I’m on EE 2.5.3 build 20120911.

Hi Jeremy,

I can try… Localization in ExpressionEngine is tied to a handful of different settings.

The Site (ExpressionEngine install) and visitors (non-logged in) are presented entry and expiration dates as set in Admin-> Localization or in the $config as you have here.

Now, since each Member of the site can be allowed to set their own Localization settings, they will see those values presented adjusted for their settings. You can set it so that all members must use the site setting outlined above.

Is the date that I choose the date for my current timezone or do I has the user need to add my offset when selecting a time?

No, but you can set it to “Fixed” which means it will use the system’s settings or “Localized” in which it will use your member localization.

Is the timestamp in the database suppose to be UTC?

Yes. Then ExpressionEngine does the math to adjust for localization.

Let me know if you have any other questions!

Cheers,

Thanks!  That pointed me in the right direction, and I think I see what was making my eyes get crossed.