Hi,
When dealing with a small set of time zones (Eastern through Pacific for example) one can drop the hours to determine the number of days between two datetimes.
2:05pm would become 12 noon. 1am would become 12 noon. So the # of days between 05:02 Aug 4, 2005 and 10:08pm Aug 10, 2005 is 6 days not 6.xxx days The granularity is a day so a small number of calculations in this manner would provide fairly accurate # of days. With a large number of calcuations, the truncating of the hours will start to become an issue.
It's a quick and dirty hack that is often sufficient for many things. We often will drop the hours when we count back in our heads.
Jason L. Froebe
Team Sybase member No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1
|