Re: interval's and printing... - Mailing list pgsql-hackers

TODO updated:
* Have SELECT '13 minutes'::interval display zero seconds in ISO  datestyle


---------------------------------------------------------------------------

Larry Rosenman wrote:
> 
> 
> --On Tuesday, June 24, 2003 10:44:25 -0400 Bruce Momjian 
> <pgman@candle.pha.pa.us> wrote:
> 
> > Larry Rosenman wrote:
> >> >> >     * Have SELECT '13 minutes'::interval display zero seconds
> >> >> you might want to clarify the TODO to include in ISO DateStyle.
> >> >>
> >> >> (Per tom's comments).
> >> >
> >> > Can you supply an example/text?
> >> * Have SELECT '13 minutes'::interval display zero seconds when using
> >> DateStyle ISO
> >
> > I am still confused.  What does such output look like.   Right now I
> > get:
> >
> >     test=> SELECT '13 minutes'::interval;
> >      interval
> >     ----------
> >      00:13
> >     (1 row)
> >     
> > I assume the idea is to display it as 00:13:00, right?
> Correct, but with Postgres DateStyle or SQL, it does other stuff:
> 
> $ psql
> Welcome to psql 7.3.3, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help on internal slash commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> ler=# set datestyle='postgres'
> ler-# ;
> SET
> ler=# select '13 minutes'::interval
> ler-# ;
>  interval
> -----------
>  @ 13 mins
> (1 row)
> 
> ler=# set datestyle='sql';
> SET
> ler=# select '13 minutes'::interval;
>  interval
> -----------
>  @ 13 mins
> (1 row)
> 
> ler=# set datestyle='iso,us';
> SET
> ler=# select '13 minutes'::interval;
>  interval
> ----------
>  00:13
> (1 row)
> 
> ler=#
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 359-1001
> >   +  If your life is a hard drive,     |  13 Roberts Road
> >   +  Christ can be your backup.        |  Newtown Square, Pennsylvania
> > 19073
> 
> 
> 
> -- 
> Larry Rosenman                     http://www.lerctr.org/~ler
> Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
> 
> 
> 
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073