Query to pull the data between Yseterday 6AM to today 6AM ...

  SELECT 
  lot_id,
  log_time,
  batch_no,
  eqp_id,
  STATION_ID,
  EXTRACTVALUE (META_DATA, '/lot_info/A3') AS A3,
  EXTRACTVALUE (META_DATA, '/lot_info/A3Info') AS A3Info,
  EXTRACTVALUE (
    META_DATA,
    '/lot_info/apc_status_info'
  ) AS apc_status_info 
FROM
  t_dlis_log_history 
WHERE (
    (EQP_ID = 'ALC4360') 
    OR (EQP_ID = 'ALC4361') 
    OR (EQP_ID = 'ALC1360') 
    OR (EQP_ID = 'ALC1361') 
    OR (EQP_ID = 'ALC1362') 
    OR (EQP_ID = 'ALC1363') 
    OR (EQP_ID = 'ALC1364') 
    OR (EQP_ID = 'ALC1365') 
    OR (EQP_ID = 'ALC355') 
    OR (EQP_ID = 'ALC353') 
    OR (EQP_ID = 'ALC4350') 
    OR (EQP_ID = 'ALC354')
  ) 
  AND ((
    log_time >= DATEADD (
      HOUR,
      6,
      CONVERT(VARCHAR (10), GETDATE (), 110)
    ) 
    AND (
      log_time <= DATEADD (
        HOUR,
        6,
        CONVERT(VARCHAR (10), GETDATE () + 1, 110)
      )
    )
  )

It is showing error missing expression ...