A Handy SQL Timestamp Function
July 9, 2008 Hey, Ted
|
I have found a great tool for working with timestamp data. I have used it for performance tracking and analyzing data intervals. It’s SQL’s Timestampdiff function, and I think you should tell readers of Four Hundred Guru about it. Timestampdiff returns the difference between two timestamps in the interval of your choice. The first parameter for the timestampdiff function is the interval to use. Valid values for this parameter are:
|
|
In recent articles, I discussed some techniques for preventing your subsystems from restarting after a full system backup; turning off your iSeries, System i, and Power i attention lights; and preparing to add disk drives to your system. After publishing these tips, several readers wrote in with corrections, additions, and stories that flesh out the techniques even further. This week, let’s look at what you had to say and see what additional information we can pick up from them. More On Stopping Your System i From Starting Up After printing a tip on stopping your controlling subsystem from restarting after |
