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
