query that shows appointments in two days from "today"

Database
N/A

query that shows appointments in two days from "today"

Hello All!

I successfully create a csv from nightly query run in sybase i Anywhere using Sybase Central.:

BEGIN
UNLOAD
SELECT phone_home_client, appt_date, appt_time, staff_email,crecordnumber
FROM outcomes WHERE specifier1 = 'TASC' AND phone_opt_in = 'Yes'
TO '/srv/phonedialer_out/phase1sys1.csv';
END

I have found I need to have only those appointments exported that are 2 days from "today".

Is there a way I can include a statement that gives only those appointments that are two days away? I have googled and read and cannot find a solution.

Thanks for any help!
1 REPLY
N/A

Re: query that shows appointments in two days from "today"

You should post Sybase questions on a Sybase forum :-)

In Teradata it would be an additional WHERE-condition
AND appt_date = current_date + 2

Dieter