I am collecting plant data (mostly alarms) into an 8i database. The collecting tables execute a trigger that pair the data. For example, every alarm gets an 'in' time paired with an 'out' time.
ALARM1 in 1:50 out 2:15
When daylight savings time hits I could get
ALARM1 in 1:50 out 1:15
My question is, do any of you have a similar situation? What is the best way to handle the 'missing' hour for daylight savings time?
I was thinking of collecting the first hour and updating the year on it in order to separate it. I beleive this will work ok for me except the pairing of data will have to be manually repaired. We don't think we want to deal with converting to Gren. time either.
