Inserting Values into Interval

Поиск
Список
Период
Сортировка
От BlackMage
Тема Inserting Values into Interval
Дата
Msg-id 24153731.post@talk.nabble.com
обсуждение исходный текст
Ответы Re: Inserting Values into Interval  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hey,

I am having a small issue when entering values into the interval field. Say
I want to enter a time of 2:03, two minutes and 3 seconds. When I insert
that into an interval field, it comes up at 02:03:00, 2 hours, 3 minutes.
The only way I've gotten around this so far is by doing 00:02:03. But I was
wondering if there is another of inserting into an interval field where the
values will start at the lower end first, so the result will be 00:02:03
when 2:03 is inserted?

This will make developing application so much easier if there is, so thanks.
--
View this message in context: http://www.nabble.com/Inserting-Values-into-Interval-tp24153731p24153731.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


В списке pgsql-general по дате отправления:

Предыдущее
От: Gerry Reno
Дата:
Сообщение: Re: Replication
Следующее
От: DaNieL
Дата:
Сообщение: Why my queryes doesnt not use indexes?