Re: [HACKERS] interval's and printing...

[Larry Rosenman]

--On Tuesday, June 24, 2003 10:44:25 -0400 Bruce Momjian 
<[EMAIL PROTECTED]> 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
  [EMAIL PROTECTED]               |  (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: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly