Re: Subtle error.....(Enough to cause a nervous breakdown!!)
Date: 5 Jul 1994 16:31:15 GMT
Message-ID: <2vc1t6$2c5_at_News.Simplex.NL>
Mark J. Bobak (mbobak_at_tr1106.to.ford.com) 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
^^ Oh no! Yes. it's a MONTH!!! let's try MI
: 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.
: --
: Mark J. Bobak
: Truck Operations
: Ford Motor Company
: bobak_at_mailhost.to.ford.com
Received on Tue Jul 05 1994 - 18:31:15 CEST