Inserting Values into Interval

From: BlackMage <dsd7872(at)uncw(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Inserting Values into Interval
Date: 2009-06-22 19:24:17
Message-ID: 24153731.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dario Teixeira 2009-06-22 20:57:58 Re: Information about columns
Previous Message Scott Marlowe 2009-06-22 18:56:58 Re: Select ranges based on sequential breaks