Re: *USA Time

["Lennon_s_j@xxxxxxxxxxx" <lennon_s_j@xxxxxxxxxxx>]

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