RE: FWD: Anyone had any Y2K bugs yet?

7.31UC2A AIX 4.3.2 the following works fine. set isolation to dirty read; SELECT create_dttm, order_id FROM order WHERE create_dttm > "2000-01-01 00:00:00" AND create_dttm < "2000-02-23 23:59:59" order by create_dttm How many records do you expect go get back? What happens if you take the order by out? What is the query plan for your query? What are the results of "1999-12-31 00:00:00" You might have to many records and/or a bad query plan or something of that sort... Or maybe you are just retrieiving alot of data. Will >===== Original Message From D.Penfold@Libertel.nl ===== >Hi, I sent this email on Wednesday, and haven't had any replies yet. Has >none else experieneced this? > >Dom: > > >> Running informix 7.30.UC7 on HP-UX 10.20 >> >> run the following query from dbaccess or the in house application: >> >> >> set isolation to dirty read; >> SELECT cdredr_t, charge_start_dt, net_usg_b_type, serv_nature, >> a_cat,b_tel_id,charge_dur, whole_ndisc_value, retail_disc_value, >> int_rec_no, a_mob_id, serv_type,serv_code, serv_qual,a_equi_id, >> rec_type, >> usage_dur, tariff_class, charge_data_vol, non_charge_data FROM >> sna_history_cdr WHERE a_tel_id = "0650800999" AND charge_start_dt >= >> "2000-01-01 00:00:00" AND charge_start_dt <= "2000-02-23 23:59:59" >> ORDER >> BY charge_start_dt DESC>> >> From dbaccess, you see "isloation level set", and nothing else until you >> do CTRL-C. The problem is the 1st date. Modifications to the date do not >> stop the problem, unless you modify one of the 1st 2 numbers, i.e.: >> >> 2000-01 etc etc will not work no matter what numbers come after it, but >> >> >> 2001-01 >> >> or >> >> 2000-02 will work. >> >> So it looks as if anything in the month of january 2000 is out. I don't >> think that DBDATE or DBCENTURY would influence this. >> >> Any ideas? >> >> Dom ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------