There are also timezones off by 15 minutes (although only a few, mainly Nepal).
The only integer representation I've ever seen is in 15 minutes units. http://www.timeanddate.com/time/time-zones-interesting.html On Tue, Dec 17, 2013 at 12:33 PM, Bruce Momjian <[email protected]> wrote: > On Tue, Dec 17, 2013 at 06:07:38PM +0100, Pavel Stehule wrote: > > Hello > > > > > > 2013/12/17 Pavel Stehule <[email protected]> > > > > > > > > > > 2013/12/17 Tom Lane <[email protected]> > > > > Alvaro Herrera <[email protected]> writes: > > > Yeah, I think a constructor should allow a text timezone. > > > > Yes. I think a numeric timezone parameter is about 99% useless, > > and if you do happen to need that behavior you can just cast the > > numeric to text no? > > > > > > yes, it is possible. Although fully numeric API is much more > consistent. > > > > > > > > I was wrong - there are timezones with minutes like Iran = '1:30'; > > > > so int in hours is bad type - so only text is probably best > > I think India is the big non-integer timezone offset country: > > http://www.timeanddate.com/worldclock/city.html?n=176 > UTC/GMT +5:30 hours > > -- > Bruce Momjian <[email protected]> http://momjian.us > EnterpriseDB http://enterprisedb.com > > + Everyone has their own god. + > > > -- > Sent via pgsql-hackers mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >
