Hi,
Or you can
selet to_char(date_column, 'mm/yyyy') from your__table;
Wednesday, August 23, 2000, 7:35:49 PM, you wrote:
SB> Hi
SB> Try this, works ok for me.
SB> private int getMaxDay(String dt) {
SB> SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
SB> Date d = new Date();
SB> try {
SB> d = sdf.parse(dt); // parse a date from a string
SB> }
SB> catch(ParseException e) {
SB> System.out.println(e);
SB> }
SB> date.setTime(d);
SB> date.getTime();
SB> return date.getActualMaximum(Calendar.DATE);
SB> }
SB> Scott
SB> ----- Original Message -----
SB> From: "Kommana, Sridhar" <[EMAIL PROTECTED]>
SB> To: <[EMAIL PROTECTED]>
SB> Sent: Thursday, August 24, 2000 7:50 AM
SB> Subject: month --end of month -- year format
>> Hi,
>> iam getting month(2) and year(2000) from the databse(oracle) for given
SB> value.i need to display in the following format
>> month/end of month/year(2/29/2000).can anybody suggest the function in
SB> either oracle or java.
>>
>> Thanks in advance,
>>
>>
SB> ===========================================================================
>> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
SB> JSP-INTEREST".
>> 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
SB> ===========================================================================
SB> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
SB> Some relevant FAQs on JSP/Servlets can be found at:
SB> http://java.sun.com/products/jsp/faq.html
SB> http://www.esperanto.org.nz/jsp/jspfaq.html
SB> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
SB> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
--
Best regards,
java_jason mailto:[EMAIL PROTECTED]
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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
