This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Database Oracle 8i. My program is a calendar JSP where mm/dd 1 through 9 are a single digit. When I use <%! public final static String GET_DAYS_EVENTS_QUERY = "SELECT name, event_id, start_date FROM Events " + "where to_char(start_date,'yyyy') = ? " + " and to_char(start_date, 'mm') = ? " + " and to_char(start_date, 'dd') = ? " + "ORDER BY event_id"; %> <% the database is looking for two digits to be placed in mm/dd. Is there another way to write the select statement where the database will understand a single digit mm/dd, example(3-1-2001)? Thanks