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
