Query

[sandy1028]

Hi,

 

These are the fields in the table.

timestamp

state    | varchar(1)    | YES  |    | NULL             

| cputime  | varchar(12)  | YES  |    | NULL               

| memused  | decimal(10,2) | YES  |    | NULL     

 

The values in fieldname state changes from R to C when the task is completed.

 

Please help me with a query how can we find the timetaken to change the state from R to C.

[~n[EO]n~]

UPDATE timestamp SET state='C' WHERE id=1;

 

 

[sandy1028]

The change of  state from R to C is dynamic when the particular task is completed.

 

How can we find the time taken when the state changed to C.

When state changes is there any query to find the particular timestamp.

[~n[EO]n~]

I didn't understand what are you trying to do.

 

How can we find the time taken when the state changed to C.

 

How is the state going to change, with any events or what ?

 

 

[sandy1028]

When the task or job is completed the state is changed to C from R,

ie from running to completed state.

 

Can we find the time between R to C

[~n[EO]n~]

Yes you can, store the time in a variable when the task has started and completed

 

<?php $timestart=date("H:i"); //  get the time
        /// do  your task here 
       $timecomplete=date("H:i");
      /// after that 
     deduct the time difference and save it 
    $timetaken = $timecomplete - $timestart;

?>

 

But how will the task occur, by pressing some buttons or what ???

[mezise]

Hi,

 

the simplest way to do exactly what you've described is adding to your INSERTS/UPDATES information of start times when a record enters appropriate state, e.g. datetimeOfRState and datetimeOfCState. Then to obtain the taken time you just need to select a difference of these times. Times when a record enters given state may also be maintained using TRIGGERS.

 

If your description is incomplete you must notice that this way is only for one change from state R to C. When you are not sure if requirements will change safer way is to create special table that will store information of changing states.

 

Michal