Re: *USA Time

FWIW: I ran this SQL twice:

SELECT
time('00:00:00')+ 1 seconds,
time('24:00:00')+ 1 seconds,
time('12:00:00')+ 1 seconds FROM sysibm/sysdummy1

Using *HMS time format the results are:
Time expression Time expression Time expression
00:00:01 00:00:01 12:00:01

(00:00:00 and 24:00:00 are considered the same)

Using *USA format the results are:
Time expression Time expression Time expression
00:00 AM 00:00 AM 12:00 PM

(The seconds get truncated.)

Sam

On 1/4/2011 2:57 PM, Kurt Anderson wrote:

How is it that the *USA version of midnight is 00:00 AM and not 12:00 AM? Do digital clocks in the U.S. display 00:00 AM? I know stopwatches will display 00:00 at the start.

Little did I know, 12:00 AM is the *hival version of the date, which results in an *ISO time value of 24.00.00, which isn't a valid time value. Got burned by this. My own fault, I know, for not verifying to see if 12:00 AM was actually midnight.

End result, when displaying time in *USA, it will be in the USA format 1439/1440 of the time.

This on top of a long day.

Kurt Anderson
Sr. Programmer/Analyst
CustomCall Data Systems