Re: [GENERAL] Inserting Values into Interval

2009-06-24 Thread Jasen Betts
On 2009-06-23, BlackMage dsd7...@uncw.edu wrote: Well what format should be used then? The application works like this. Users use a watch time how fast they run from point A to point B. Afterwards they enter the time taken, say 5 minutes 39 seconds, into a field. The field already checks to

Re: [GENERAL] Inserting Values into Interval

2009-06-23 Thread BlackMage
Tom Lane-2 wrote: BlackMage dsd7...@uncw.edu writes: 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

[GENERAL] Inserting Values into Interval

2009-06-22 Thread BlackMage
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.

Re: [GENERAL] Inserting Values into Interval

2009-06-22 Thread Tom Lane
BlackMage dsd7...@uncw.edu writes: 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