Re: Pro*C date question
From: Joe Fulson-Woytek <joefw_at_eosdev2.gsfc.nasa.gov>
Date: 22 Dec 1994 20:31:40 GMT
Message-ID: <3dcnnc$g6t_at_post.gsfc.nasa.gov>
Date: 22 Dec 1994 20:31:40 GMT
Message-ID: <3dcnnc$g6t_at_post.gsfc.nasa.gov>
Thanks to all who so quickly and more importantly correctly answered my pro*c question - the solution for those who are interested is to not enclose the date variables in quotes. I was doing this:
WHERE TO_CHAR(SHIP_DATE,'DD-MON-YY')= ':proc_date';
and instead should do this:
WHERE TO_CHAR(SHIP_DATE,'DD-MON-YY')= :proc_date; : Received on Thu Dec 22 1994 - 21:31:40 CET