Inserting Values into Interval - Mailing list pgsql-general

From BlackMage
Subject Inserting Values into Interval
Date
Msg-id 24153731.post@talk.nabble.com
Whole thread Raw
Responses Re: Inserting Values into Interval
List 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 by date:

Previous
From: Gerry Reno
Date:
Subject: Re: Replication
Next
From: DaNieL
Date:
Subject: Why my queryes doesnt not use indexes?