I currently have a query that runs daily at night to capture interval data from that day.
The syntax I use to capture this data is:
WHERE (RECORD_TYPE = 'INTERVAL')
AND DATE_TIME BETWEEN
CONVERT (varchar(8), GETDATE(),1) + ' 00:00:00' AND
CONVERT (varchar(8), GETDATE(),1) + ' 23:59:00'
The data is stored in the following format:
5/14/2003 7:00:00 AM
My question is - How can I go back to get data that I might have missed from previous days?
The information is from a Melita Predictive dialer and stored in Sybase.
Thanks,
Kevin
The syntax I use to capture this data is:
WHERE (RECORD_TYPE = 'INTERVAL')
AND DATE_TIME BETWEEN
CONVERT (varchar(8), GETDATE(),1) + ' 00:00:00' AND
CONVERT (varchar(8), GETDATE(),1) + ' 23:59:00'
The data is stored in the following format:
5/14/2003 7:00:00 AM
My question is - How can I go back to get data that I might have missed from previous days?
The information is from a Melita Predictive dialer and stored in Sybase.
Thanks,
Kevin