database - Storing Date with timezone -
i have been working oracle db long time , have been storing dates without bothering timezone. have issue client , server in different timezones , need perform date/time conversion according timezone. has opened lots of questions now: should store date/time along timezone or not? asking because if servertimezone changes data corrupted. if oracle db server located in particular region should run on local timezone? there standard this? my second point in relation dr database servers located in different regions have same data prod db. if timezones not same both db in trouble. to able show clients date in timezone need offset. example, server runs in edt , saved time years. data saved way. so, need create field, store offset each user. need apply offset each date/time field on select. how this, have no idea - because have no idea how use data. select statement, report, or website? if application, client load user info including offset. example, user in edt have offset ...