0

I haven't been able to get AWS support on the line and need an answer asap - do the SQL instances on Amazon Web Services RDS use daylight savings? I know the timezone is UTC but not sure if it uses DST....

1

UTC does not have daylight savings time.

See also http://en.wikipedia.org/wiki/Coordinated_Universal_Time#Daylight_saving_time:

UTC does not change with a change of seasons, but local time or civil time may change if a time zone jurisdiction observes daylight saving time (summer time). For example, local time on the east coast of the United States is five hours behind UTC during winter, but four hours behind while daylight saving is observed there.

1

As previously stated, UTC does not observe daylight savings. Hence it's "universal" nature.

However, if your application is telling MySQL to change timezones when it connects with SET TIMEZONE = 'Europe/London'; for instance, then your RDS's NOW() and other time related functions WILL observe daylight savings.

If you (or your application) does not set the timezone upon connect (with RDS it's impossible to change the timezone within MySQL's global configuration), then it will behave as such with UTC, and not observe any daylight savings rules.

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.