Re: Time handling in pgsql. (fwd)
От | Jeff MacDonald |
---|---|
Тема | Re: Time handling in pgsql. (fwd) |
Дата | |
Msg-id | FJENKCLABGGBKBDGHOJJCEPGCAAA.jeff@interchange.ca обсуждение исходный текст |
Ответ на | Time handling in pgsql. (fwd) (nolan@celery.tssi.com) |
Ответы |
Re: Time handling in pgsql. (fwd)
Re: Time handling in pgsql. (fwd) |
Список | pgsql-general |
Actually I'd be happy if i could simply do this SELECT age(start,end)::seconds From foo; or something very close to that. Then i could process the rest in perl. Jeff. >> From: pgsql-general-owner@postgresql.org >> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of >> nolan@celery.tssi.com >> Subject: [GENERAL] Time handling in pgsql. (fwd) >> It would be great if the 'age' function could be supplied a formatting >> string so that you could format the data any way you want. >> Within that function convert both timestamps into seconds, do >> the arithmetic and return the number of seconds. >>
В списке pgsql-general по дате отправления: