When I Am Trying To Execute This Query

See more:

SQL

DECLARE @PDate datetime
  UPDATE MASTERPROCESSDAILYDATA SET Status =  CASE WHEN  CAST(@PDate AS TIME ) BETWEEN CAST ('08:00' AS TIME)
             AND CAST('09:30'  AS TIME) THEN 'P'
             WHEN  CAST(@PDate AS TIME ) BETWEEN CAST ('16:00' AS TIME)
             AND CAST('17:30'  AS TIME) THEN 'P'
              WHEN  CAST(@PDate AS TIME ) BETWEEN CAST ('09:31' AS TIME)
             AND CAST('15:59'  AS TIME) THEN 'HL'
             ELSE 'A'

            END
            SELECT *FROM MASTERPROCESSDAILYDATA where PDate ='02-1-13'

when i am trying to execute this query, Status is updated only ELSE Condition(DEFAULT)
Can anyone help me to solve this problem


@PDate datetime
@In_Punch datetime
@Out_Punch datetime