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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
