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

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