3 Replies Latest reply: Nov 18, 2014 12:20 AM by PAUL YEO RSS

    SQL load script how to compute start and end time as download ?

    PAUL YEO

      Hi All

       

      I want to know how to write in SQL for the above mentioned.

       

      after load below script :-

       

      CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SA;Initial Catalog=andonDatabas;Data Source=Paul;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PAUL;Use Encryption for Data=False;Tag with column collation when possible=False];

       

       

      select * from record_produksi_plc;

       

       

      select * from record_downtime_plc;

       

       

      select * from record_reject_detail_plc;

       

      I get 2 field name , downtime_start_time and downtime_stop_time. i like to compute :-

       

      downtime=downtime_start_time - downtime_stop_time


      How to do it ?


      Paul