Re: Subtle error.....(Enough to cause a nervous breakdown!!)

In article <2v1qroINNe9k_at_ope001.iao.ford.com>, mbobak_at_tr1106.to.ford.com (Mark J. Bobak) wrote:

> I was writing a couple of simple sql queries the today, for a table that already
> has a form defined, and this is what I ran across:
>
> Form was outputting times: 12:00:00, 12:30:00, 12:59:00, 03:00:00, which were
> correct. I was expecting to get the same thing out of my sql query. Instead
> I got: 12:06:00, 12:06:00, 12:06:00, 03:06:00.
>
> After staring at the query which looked something like:
>
> select to_char(time_col,'HH:MM:SS') from table1 where
> blah = 'blah1';
>
> for hours and hours, I asked a co-worker, and he saw the problem imediately.
>
> AAAAAAAAARRRRRRRRRRRRRRRRRGGGGGGGGGGGGGGGGGHHHHHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!
>
> I was about ready to burst.....at least I can go home for the weekend in peace.
>
> sheesh....
>
>
> --
> Mark J. Bobak
> Truck Operations
> Ford Motor Company
> bobak_at_mailhost.to.ford.com

Sorry but I got 12:07:00, 12:07:00, 12:07:00, 3:07:00

(Somebody willing to explain me the difference between Minutes and Months?) (Couln't resist ;-)
LM

-- 
Leo Mannhart
Planning Office
University of Zurich               phone: ++41 1 257 23 34
Kuenstlergasse 15                    fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland        eMail: mannhart_at_zuv.unizh.ch