| 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: | Whole Thread | Raw Message | 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.
| 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 |