You can check out this link for Oracle related issues. You need to be registered to use this site but the registration is free. Lots of information about Oracle. http://technet.oracle.com/ -----Original Message----- From: cedric sk chin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 2:45 AM To: [EMAIL PROTECTED] Subject: [OT] query year in oracle date field - URGENT hi fellow developers, can anyone give me some ideas on this? say if users wish to query the records for the year 1999, what should i do? i have a whole lot of records ranging from 1991 to 2001 as in oracle data field, "dd-mm-yy", so in this case what should i do in order to extract the records which fall on the year 1999? thanks for any ideas/suggestions. cheers, cedric __________________________________________________________________ Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/ =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
