On Mon, Mar 22, 2004 at 08:32:32 -0300, Martin Marques <[EMAIL PROTECTED]> wrote: > > Is there information on how other intervals are taken? I mean, how is '1 year' > afected with the leap years?
Intervals are stored as two components. One is absolute time difference, and the other is in months. '1 year' is equivalent to '12 months'. The documentation on how they work in corner cases (when added or subtracted from timestamp(tz)) is sparse. It isn't documented whether the part in months or the absolute time is added first or what timezone is used (for timestamptz) when adding the months part. The basic idea is that months are added by looking at the timestamp as date and time and adding the appropiate number of months to the date and then converting back to a timestamp. It isn't documented what happens when the day of the month is past the end of the new month, but it looks like the last day of new month is used. If you convert an interval to an absolute time (such as by extracting the epoch), then months are converted to 30 days. Again, I don't think this is documented. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
