Darn SQL people, finding the odd cases... take a look at the attached doc...
________________________ Roland Gaspar Tel.: (514) 398-7880 xt 8603 ICQ # 1355591 www.roland-gaspar.com >>> [EMAIL PROTECTED] 04/03/03 09:46AM >>> Changing it from minutes to seconds will only influence newly created records, SA will not modify any records that are already in the DB. Also the structure of the DB/table will not change if you change from minutes to seconds. dirk. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roland Gaspar Sent: Thu Apr 03 4:36 PM To: [EMAIL PROTECTED] Subject: [SA-list] Statistical Database Question Hi, am having an in-house programmer write an SQL query based on uptime.pl (from Jack Lyons)... she came back to me with a headache "on real date field, no real time field" and "damn that minute field is imprecise"... here's my question, I have 3 weeks worth of stats in an Oracle DB, what would be the effect of ,at this time, changine the "timing" unit from minutes to seconds on the data that is already there? Would the table need to be re-created? would SA multiply the timing values already there by 60? I ask because she's begging me not to make her continue parsing the "prev change stats" "current change state" into real date/time fields.. she's very close, but the day change bothers her... Thanks, (BTW, will be glad to share when it's done) ________________________ Roland Gaspar Tel.: (514) 398-7880 xt 8603 ICQ # 1355591 www.roland-gaspar.com To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive xxxxxxxx Ce message a �t� analys� par Guinevere2 et McAfee This message was Scanned by Guinevere2 and McAfee http://cheese.patlq.com/guinevere.htm Questions? [EMAIL PROTECTED] xxxxxxxx
select * from sa_stats where PREVIOUSSTATUSCHANGE like ' %'; SAID HOST UNIQUEID STATUS PREVIOUSSTATUS LASTSTATUSCHANGE PREVIOUSSTATUSCHANGE TIMING --------------- -------------------------------------------------- ---------- ---------- -------------- -------------------------- -------------------------- ---------- NT Mail Flow 17 6 0 3/17/03 2:20:14 PM 54284540 NT Oracle9iAs (DNS) 134 5 1 3/30/03 12:33:36 AM 54302433 select * from sa_stats where host = 'Oracle9iAs (DNS)'; SAID HOST UNIQUEID STATUS PREVIOUSSTATUS LASTSTATUSCHANGE PREVIOUSSTATUSCHANGE TIMING --------------- -------------------------------------------------- ---------- ---------- -------------- -------------------------- -------------------------- ---------- NT Oracle9iAs (DNS) 134 1 5 3/29/03 7:37:40 PM 3/27/03 6:21:51 PM 2956 NT Oracle9iAs (DNS) 134 5 1 3/30/03 12:33:36 AM 54302433 NT Oracle9iAs (DNS) 134 1 5 4/1/03 1:37:29 AM 3/30/03 12:33:36 AM 2944 NT Oracle9iAs (DNS) 134 5 1 4/1/03 9:22:04 AM 4/1/03 9:19:15 AM 3 NT Oracle9iAs (DNS) 134 1 5 4/3/03 10:03:45 AM 4/1/03 9:22:04 AM 2921 NT Oracle9iAs (DNS) 134 5 1 4/3/03 10:07:07 AM 4/3/03 10:03:45 AM 4 6 rows selected.
