RDS SQL Instance Time Zone for UK Daylight Savings

I need to create an RDS SQL Instance with a time zone that is tolerant of UK daylight savings changes. From the RDS documentation, I can see there is a time zone called "GMT Standard Time" that is tolerant of UK daylight savings changes. If I select this time zone does the RDS SQL instance time automatically change in line with UK daylight savings?

주제

데이터베이스 마이그레이션 및 현대화 분석

태그

마이크로소프트 SQL 서버 아마존 Relational Database Service 데이터베이스 SQL 서버용 RDS Custom

언어

English

Simon Cox

질문됨 일 년 전405회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

수락된 답변

Hi,

According to https://repost.aws/knowledge-center/rds-change-time-zone

It’s a best practice to use the UTC time zone at the database layer. Because UTC doesn't observe daylight savings (DST), you don’t have to adjust the time later when it shifts.

Hope it helps and if it does I would appreciate the answer to be accepted so that community can benefit for clarity, thanks ;)

전문가

Antonio_Lagrotteria

답변함 일 년 전

RDS SQL Instance Time Zone for UK Daylight Savings

관련 콘텐츠