Determine Maximum Timestamp from a Set

raizel · #1 (**permalink**) 12-20-09, 22:13

Hi guys,

Probably most or some of you know the solution to this. As the title suggests, I have a set of Timestamps. I want to get the highest timestamp.
Of course I can just use the case statement like:

Code:

CASE
WHEN
  TIMESTAMP('2004-01-26 11:50:00.000000') > TIMESTAMP('2003-04-23 08:00:00.000000')
THEN
   TIMESTAMP('2004-01-26 11:50:00.000000')
WHEN...........
THEN.....

ELSE TIMESTAMP('2003-04-23 08:00:00.000000')
end

is there an easy way to do this? Or a way that I can make it using the MAX function:

Code:

MAX(TIMESTAMP('2004-01-26 11:50:00.000000'),TIMESTAMP('2003-04-23 08:00:00.000000'),.......,......)

Thanks!

umayer · #2 (**permalink**) 12-21-09, 01:29

Yes, you can use MAX(timestamp1,timestamp2....)

raizel · #3 (**permalink**) 12-21-09, 01:34

Quote:

Originally Posted by umayer

Yes, you can use MAX(timestamp1,timestamp2....)

I tried. But its telling me that there is no authorized routine with the same signature.

Code:

SELECT MAX(A.DATE_S, B.DATE_S, C.DATE_S) AS DATE_S FROM ......

tonkuma · #4 (**permalink**) 12-21-09, 02:38

Referencing manuals,
MAX(timestamp1,timestamp2....) is supported on DB2 9.5 for LUW, DB2 Version 7 for z/OS and DB2 for iSeries.

Internet Services

Web Development

Digital Marketing

Consumer Tech