On 26 August 2015 at 01:42, Alexander Belopolsky <[email protected]> wrote:
> Speaking of DBAs, how would she feel if a system zoneinfo upgrade made her > database unreadable? A zoneinfo upgrade can easily create new gaps and > folds even in the past if someone at IANA decides that they found a better > source of historical information. Speaking as a DBA, I know that my timestamps with timezones are converted and stored as UTC time on entry so this doesn't happen. You use timestamp with timezone to store an absolute time. It does, however, mean that revisions to the IANA database may change the result when it is rendered back in its original timezone. If you don't want that, you actually want a timestamp without timezone (naive), and maybe a physical location (because the local government may declare that this year they will central time instead of mountain time). -- Stuart Bishop <[email protected]> http://www.stuartbishop.net/ _______________________________________________ Datetime-SIG mailing list [email protected] https://mail.python.org/mailman/listinfo/datetime-sig The PSF Code of Conduct applies to this mailing list: https://www.python.org/psf/codeofconduct/
