Re: age() vs. timestamp substraction - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: age() vs. timestamp substraction
Date
Msg-id 20061006065548.A16785@megazone.bigpanda.com
Whole thread Raw
In response to Re: age() vs. timestamp substraction  (Jean-Paul Argudo <jean-paul@argudo.org>)
List pgsql-sql
On Fri, 6 Oct 2006, Jean-Paul Argudo wrote:

> Hi all,
>
> > Where did you get that idea?  age's reference point is current_date (ie,
> > midnight) not now().  There are also some differences in the calculation
> > compared to a plain timestamp subtraction.
>
> I'm jumping on this thread to point out a little strange thing to me.
> CURRENT_DATE, converted (stupidly) as a string *with* hour is "current
> date at mid-day":
>
>
> test=# select to_char(current_date,'YYYY-MM-DD HH:MI:SS');
>        to_char
> ---------------------
>  2006-10-06 12:00:00
> (1 ligne)
>
> It was a day when I had to debug a strange behaviour in a customer's
> (bad) code :-)

That's both midnight and mid-day. It's asking for 12 hour time and no
AM/PM marker.


pgsql-sql by date:

Previous
From: Jean-Paul Argudo
Date:
Subject: Re: age() vs. timestamp substraction
Next
From: Graham Davis
Date:
Subject: Re: [HACKERS] timestamp subtraction (was Re: formatting intervals