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:
|