IBM Mainframe Forum

Hi,
What will be the value of WS-CURR-TIME if the statement below is executed at 24.00? Will it have 24:00:00 or 00:00:00 or 00:00:01? Is there a way to test this on my own without waiting until 24.00?

EXEC SQL
SET :WS-CURR-TIME = CURRENT TIME
END-EXEC.

Version of DB2 being used is DB2V9.1.

Thanks,
LML

Perhaps in this case rather than running a test, reading the fine manual on time values would be a preferable way to start.

Hello,

What will be the value of WS-CURR-TIME if the statement below is executed at 24.00?

This cannot happen . . .

The hours of a day are 00 thru 23,

As suggested, investing some research time in the documentation would be good.

These users thanked the author dick scherrer for the post:

letmelive (Sat Apr 27, 2013 1:53 am)

since we are on the subject : DB2 will accept '24.00.00' as a valid time which could be useful for some queries :

This cannot happen . . .

The hours of a day are 00 thru 23,

As suggested, investing some research time in the documentation would be good.

But the book actually says the numbers for hours can be 00 through 24. If the hour is 24, then the minutes and seconds will be zeroes.

Hello,

Does this mean that "old" code might have some slight difference(s) than new code that uses hr 24 in db2?

I think everyone's correct here:

• Getting the system time through, e.g., CURRENT TIME, will never produce a value of 24:00:00.
• Nonetheless, a time value of 24:00:00 is recognized as valid by DB2, and can be used for special purposes as per GuyC.
• Hi Opal!

Opal'd

These users thanked the author Akatsukami for the post:

letmelive (Sat Apr 27, 2013 1:53 am)