Re: to_date/to timestamp going to BC

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: to_date/to timestamp going to BC
Date: 2001-10-04 14:56:06
Message-ID: 20011004165606.D22302@zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Oct 04, 2001 at 07:44:14AM -0700, Josh Berkus wrote:
> Karel,
>
> > .. well, I add it to my TODO for 7.3 (I plan rewrite several things
> > in to_* functions).
>
> How about a to_char function for INTERVAL? Please, oh please?

oh, needn't please.. already in right now breeding 7.2 :-)

test=# SELECT to_char('5months 3sec 4h 1min'::interval, 'HH:MI:SS Mon');
to_char
--------------
04:01:03 May
(1 row)

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-10-04 15:02:00 Re: SQL Syntax / Logic question
Previous Message Josh Berkus 2001-10-04 14:51:46 Re: maximum parameters limit to function & manipulating array in plpgsql