I meant fixed as in unvarying. So we store our time data in EST (UTC-05:00), instead of UTC. For half the year the stored time matches the local time it's to be displayed in and so no conversion is required. The other half of the year when local time is UTC-04:00 we only need to shift the stored time by one hour to display it properly.
Many time handling libraries are extremely efficient at adding/subtracting an hour from time. This is important because we have many legacy systems using this data (think mainframe COBOL to today's latest technologies with a smattering of everything in between). So it's not just a single time handling library in use.
Many time handling libraries are extremely efficient at adding/subtracting an hour from time. This is important because we have many legacy systems using this data (think mainframe COBOL to today's latest technologies with a smattering of everything in between). So it's not just a single time handling library in use.