Postgres Pro
Downloads
Home   >   mailing lists

Re: to_date/to timestamp going to BC - Mailing list pgsql-sql

From Karel Zak
Subject Re: to_date/to timestamp going to BC
Date
Msg-id 20011004165606.D22302@zf.jcu.cz
Whole thread Raw
In response to Re: to_date/to timestamp going to BC  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Tree view 
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@zf.jcu.cz>http://home.zf.jcu.cz/~zakkr/C, PostgreSQL, PHP, WWW, http://docs.linux.cz,
http://mape.jcu.cz

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: maximum parameters limit to function & manipulating array in plpgsql
Next
From: "Josh Berkus"
Date:
Subject: Re: SQL Syntax / Logic question