2014-09-19 11:41 GMT-03:00 Sven Van Caekenberghe <[email protected]>: >>>> [1] http://www.w3.org/TR/2005/NOTE-timezone-20051013/#d2e310 >> >>> Very interesting link, really useful - Thx. >> >> At least it makes you understand some pros/cons about date implementations. >> After reading that I understood why Java's Calendar object is field based.
>> Additionally >> I would like this: >> '2014/08/31 24:00' asDateAndTime -> "2014/09/01 00:00" > Actually, > ZTimestamp fromString: '2014/08/31 24:00:00'. > => '2014-09-01T00:00:00Z' > but that is not really by design, it just does normalisation. > I am not sure what to think of that, it is certainly interesting ;-) Yes! I forgot to mention, but I did this test with ZTimestamp before and it gave me the "expected" results. I played with having ZTimestamp as the default object class for PostgresSQL's "timestamp without time zone" data type, but then I discarded this option. PostgreSQL also converts '2014-08-31 24:00' to '2014-09-01 00:00'. Regards! Esteban A. Maringolo
