Question
September 28, 2007 at 01:55 PM
vlahomt

DB2 timestamp fields

by vlahomt . Updated 19 years, 1 month ago

I am trying to compare two time stamp fields on two diffrent tables. I need to have the first entry on table b that is greater than the entry on table a that I am comparing.

so if table a’s time stamp entry is 2007-5-25.10.57.23.000001 and table b has 4 entries
2007-5-25.09.57.23.000001
2007-5-25.10.59.23.000001
2007-5-25.11.57.23.000001
2007-5-25.12.57.23.000001

I only want this entry 2007-5-25.10.59.23.000001
which is the next greatest time.

This discussion is locked

All Comments