>My method is take date()*86400+time() Is the goal to track a chronology via a single field? If so, I'd say your calulation is close. Wouldn't it be:
((DATE() - 1) * 86500) + TIME() (...as the number of days elapsed is today - 1, not today.) Regardless, you're right that the date could get humongous. For the cycles you're going through to do this calculation it would be a small step to convert it into and out of any other base to compress and decompress the bytes. The foundational question, however, is one of context. Why do you need this? That answer may limit or expand your options. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
