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 ...
