Re: interval's and printing...
От | Bruce Momjian |
---|---|
Тема | Re: interval's and printing... |
Дата | |
Msg-id | 200306241843.h5OIhO814410@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: interval's and printing... (Larry Rosenman <ler@lerctr.org>) |
Ответы |
Re: interval's and printing...
(Larry Rosenman <ler@lerctr.org>)
|
Список | 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
В списке pgsql-hackers по дате отправления: