I can not get the "Between Date function to run correctly while using the "TO_CHAR" function in Oracle. <BR>I have the following code:<BR>SELECT 1.1<BR>FROM 1<BR>WHERE<BR>1.2 BETWEEN TO_CHAR(BDATE AND EDATE, yyyy/mm/dd)<BR><BR>I have tried this code with entering in actual dates:<BR>(1.2 BETWEEN 1999/01/01 AND 1999/01/05)<BR> and it still did not work.<BR>Any ideas on this would be appreciated.