http://in.compucrete.com/index.php?action=history&feed=atom&title=Time_Fix_Queries
Time Fix Queries - Revision history
2026-05-15T15:24:25Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=Time_Fix_Queries&diff=660&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T13:00:38Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:00, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-659:rev-660 -->
</table>
WikiAdmin
http://in.compucrete.com/index.php?title=Time_Fix_Queries&diff=659&oldid=prev
Intra>User: 1 revision imported
2017-01-10T00:02:24Z
<p>1 revision imported</p>
<p><b>New page</b></p><div>=== Leave Plant vs. Ticket Date/Time ===<br />
Review Leave Plant<Ticket Date/Time<br />
<PRE>select plant_no,ticket_date,ticket_time,leave_plant_dt, <br />
cast (ticket_date||' '||cast(ticket_time/100 as char(2))||':'||cast(ticket_time-100*(ticket_time/100)<br />
as char(2)) as timestamp)+.006945 fix_LeavePlant_dt<br />
from ARTSLSHD<br />
WHERE leave_plant_dt<cast (ticket_date||' '||cast(ticket_time/100 as char(2))||':'||cast(ticket_time-100*(ticket_time/100)<br />
as char(2)) as timestamp)<br />
</PRE><br />
<br />
Fix Leave Plant:<br />
<PRE>update artslshd<br />
set leave_plant_dt=cast (ticket_date||' '||cast(ticket_time/100 as char(2))||':'||cast(ticket_time-100*(ticket_time/100)<br />
as char(2)) as timestamp)+.006945<br />
WHERE leave_plant_dt<cast (ticket_date||' '||cast(ticket_time/100 as char(2))||':'||cast(ticket_time-100*(ticket_time/100)<br />
as char(2)) as timestamp)<br />
and ticket_date='2/1/7'<br />
</PRE><br />
<br />
=== Arrive Job vs. Leave Plant ===<br />
<br />
Arrive Job Analysis:<br />
<PRE>select plant_no,leave_plant_dt, arrive_job_dt,<br />
leave_plant_dt+.020834 fix_Arrive_job_dt<br />
from ARTSLSHD<br />
WHERE arrive_job_dt<leave_plant_dt<br />
</PRE><br />
<br />
Fix Arrive Job:<br />
<PRE>update ARTSLSHD<br />
set arrive_job_dt=leave_plant_dt+.020834<br />
WHERE arrive_job_dt<leave_plant_dt<br />
and ticket_date='2/1/7'<br />
</PRE><br />
<br />
=== Return Plant vs. Leave Plant (a.m. p.m. fix) ===<br />
<br />
Return Time Analysis<br />
<PRE>select leave_plant_dt,arrive_job_dt,begin_pour_dt,end_pour_dt,leave_job_dt,return_plant_dt,return_plant_dt+.5 est_fix__ret_plt<br />
,return_plant_dt-leave_plant_dt Days_off,cast((return_plant_dt-leave_plant_dt)*1440 as integer) Mins_off<br />
from ARTSLSHD<br />
WHERE RETURN_PLANT_DT<LEAVE_PLANT_dt<br />
</PRE><br />
<br />
Return Time Fix<br />
<PRE>update ARTSLSHD<br />
set return_plant_dt=return_plant_dt+.5 where<br />
RETURN_PLANT_DT-LEAVE_PLANT_dt between -1.0 and -.5<br />
</PRE><br />
<br />
=== Elapsed Time ===<br />
<br />
<PRE><br />
select plant_no,ticket_date,ticket_time,return_plant_dt, <br />
cast (ticket_date||' '||cast(ticket_time/100 as char(2))||':'||cast(ticket_time-100*(ticket_time/100)<br />
as char(2)) as timestamp) Ticket_dt,<br />
cast (.005+1440*(return_plant_dt-cast (ticket_date||' '||cast(ticket_time/100 as char(2))||':'||cast(ticket_time-100*(ticket_time/100)<br />
as char(2)) as timestamp)) as integer) Fix_elapsed,elapsed_time<br />
from ARTSLSHD<br />
WHERE ticket_date>'2/1'<br />
and return_plant_dt>cast (ticket_date||' '||cast(ticket_time/100 as char(2))||':'||cast(ticket_time-100*(ticket_time/100)<br />
as char(2)) as timestamp)<br />
rows 1 to 1000</PRE><br />
<br />
<PRE><br />
update artslshd set<br />
elapsed_time=cast (.005+1440*(return_plant_dt-cast (ticket_date||' '||cast(ticket_time/100 as char(2))||':'||cast(ticket_time-100*(ticket_time/100)<br />
as char(2)) as timestamp)) as integer) <br />
from ARTSLSHD<br />
WHERE ticket_date>'2/1'<br />
and return_plant_dt>cast (ticket_date||' '||cast(ticket_time/100 as char(2))||':'||cast(ticket_time-100*(ticket_time/100)<br />
as char(2)) as timestamp)<br />
</PRE><br />
NOTE: This query overrides existing elapsed times. Consider a more stringent where clause.</div>
Intra>User