--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