hey Hung
it is very simple just change the formate of your date using to_date()
function provided by oracle and then select all fields which fall under 1999
I hope this will help u
Regards Preeti
----- Original Message -----
From: Hung Yee <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 10:59 AM
Subject: Re: [OT] query year in oracle date field - URGENT
> 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
>
===========================================================================
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
