Ed prochak wrote:
> moe_fiddle_at_thegolfcourse.com (moe) wrote in message news:<910a3d79.0407230635.183e15e_at_posting.google.com>...
>
>>>Making it hard on yourself. Why not create do this:
>>>
>>>CREATE TABLE app_log (
>>>output VARCHAR2(4000),
>>>outwhen TIMESTAMP DEFAULT SYSTIMESTAMP);
>>>
>>>Then output into it whatever and whenever you want?
>>>
>>>Daniel Morgan
>>
>>That is what I do use. Except for the outwhen column that you
>>suggested. I dont need that for the moment.
>>
>>Still it did not help me find a problem with Intervals. I did not know
>>that creating an interval with:
>>
>> INTERVAL '600' SECONDS; -- (newbie error yes i know: INTERVAL '10'
>>MINUTES works).
>>
>>and then comparing it to an interval generated by two date would yield
>>some results that are not really true. Plus the printing of them is
>>terrible. Try putting that into your table and you will see 00
>>00:00:00.000000. I think I need a drink and some sleep.
>>
>>It makes me go nuts i say!!!!!!!!!!!!!
>
>
> I quess you never programmed in assembler on a machine that has only a
> serial port and a few LEDs for output devices!
>
> Just my thoughts.
> Ed
Maybe we should make everyone do an internship with breadboards or punch
cards. Then they'd appreciate what they've got. ;-)
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue Jul 27 2004 - 23:14:42 CDT
