On Wed, 2 Dec 2009 00:29:10 -0600 Ron Thomas <[email protected]> wrote:
:>I have 2 timetsamps fields of 26 bytes, i need to compare both of them and :>find out which one is greater, is there any sample routine which will take care :>all the critera's involved? As you say 26 bytes, I would presume that the field is a DB2 timestamp. You can use the DB2 TIMESTAMP function to convert each to binary and then do a compare. -- Binyamin Dissen <[email protected]> http://www.dissensoftware.com Director, Dissen Software, Bar & Grill - Israel Should you use the mailblocks package and expect a response from me, you should preauthorize the dissensoftware.com domain. I very rarely bother responding to challenge/response systems, especially those from irresponsible companies. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
