WikiAdmin: 1 revision imported

2023-07-14T12:58:50Z

1 revision imported

← Older revision

Revision as of 12:58, 14 July 2023

Chanson: Created page with "How to update bad times in inventory transactions. Some programs do not properly protect HHMM to ensure hours are between 00 and 23 and minutes between 00 and 59. Diagnose b..."

2017-12-22T16:11:37Z

Created page with "How to update bad times in inventory transactions. Some programs do not properly protect HHMM to ensure hours are between 00 and 23 and minutes between 00 and 59. Diagnose b..."

New page

How to update bad times in inventory transactions. Some programs do not properly protect HHMM to ensure hours are between 00 and 23 and minutes between 00 and 59.

Diagnose bad times:
<PRE>
select *
from artprtrx
where (cast(trx_time / 100 as integer) > 23) or (cast(mod(trx_time, 100) as integer) > 59)
</PRE>

Diagnose bad times with sample fixes:
<PRE>
select
trx_time, 100*(trx_time/100) "Hrs",
trx_time - 100*(trx_time/100) "Wrong Min",
100*(trx_time/100)+59 "New Time"
from artprtrx
where
trx_time - 100*(trx_time/100) >59
</PRE>

Update minutes >59:
<PRE>
update artprtrx
set trx_time = 100*(trx_time/100)+59
where
trx_time - 100*(trx_time/100) >59
and trx_date >= :"Starting"
</PRE>

Update times >2359:
<PRE>
update artprtrx
set trx_time = 2359
where
trx_time >2359
and trx_date >= :"Starting"
</PRE>

Identify and Fix bad Transaction Times - Revision history

WikiAdmin: 1 revision imported

Chanson: Created page with "How to update bad times in inventory transactions. Some programs do not properly protect HHMM to ensure hours are between 00 and 23 and minutes between 00 and 59. Diagnose b..."