Home > mailing lists

8.3: timestamp subtraction - Mailing list pgsql-general

From	Havasvölgyi Ottó
Subject	8.3: timestamp subtraction
Date	May 23, 2009 12:01:18
Msg-id	34608c0c0905230501h1aa5f035r391a049f59995e48@mail.gmail.com Whole thread Raw
Responses	Re: 8.3: timestamp subtraction ("Daniel Verite" <daniel@manitou-mail.org>)
List	pgsql-general

Hi,

I don't know why this query returns false:

SELECT '20040506 070809.010000'::timestamp(6) - '20010203 040506.007000'::timestamp(6) = '1188 day 3 hour 3 minute 3 second 3 millisecond'::interval;

If I just subtract the two timestamps, its result is the interval I specified.

What may cause this?

Thanks,

Otto

From: Filip Rembiałkowski
Date: 23 May 2009, 11:24:34
Subject: Re: Asssociative Arrays: Best practices / snippets?

From: Benjamin Smith
Date: 23 May 2009, 12:48:03
Subject: Re: Aggregate Function to return most common value for a column