getting NaN/NaN/0NaN value instead of Date and time
Hi,
This is VaniRathna i am very new to java. l have a Actionclass which displays the values from my data Base. i have a table with the name b_announcements and with the columns [ u_id,name,start_date,end_date,information,status ] for start_date,end_date i took data type as time stamp with time zone but when i am trying to display them in grid they are displaying like NaN/NaN/0NaN how can i resolve this my code is like this
Code java:
/**
* Displays announce in grid
*/
package com.codon;
import java.io.Reader;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Iterator;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
public class ShowAnnounce extends Action{
private final String SUCCESS="success.jsp";
public ActionForward execute(ActionMapping mapping,ActionForm form,
HttpServletRequest request,HttpServletResponse response)
throws Exception
{
try{
ServletOutputStream sos=response.getOutputStream();
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setContentType("text/xml");
Reader reader=Resources.getResourceAsReader("Xml/SqlMapConfig.xml");
SqlMapClient sqlMap=SqlMapClientBuilder.buildSqlMapClient(reader);
ArrayList list=(ArrayList)sqlMap.queryForList("announcedetails",null);
Iterator itr=list.iterator();
DateFormat formatter;
formatter = new SimpleDateFormat("yyyy/MM/DD");
sos.println("<dataset>");
while(itr.hasNext())
{
B_Announce element=(B_Announce)itr.next();
sos.println("<item>");
sos.println("<announce_id>"+element.getAnnounce_id()+"</announce_id>");
sos.println("<name>"+element.getName()+"</name>");
sos.println("<start_date>"+element.getStart_date()+"</start_date>");
sos.println("<end_date>"+element.getEnd_date()+"</end_date>");
sos.println("<information>"+element.getInformation()+"</information>");
sos.println("<active>"+element.getActive()+"</active>");
//sos.println("<checked_out>"+element.getChecked_out()+"</checked_out>");
sos.println("</item>");
}//while
sos.println("</dataset>");
}catch(Exception e)
{
e.printStackTrace();
}
return null;
}//execute
}
thank you for any help
Re: getting NaN/NaN/0NaN value instead of Date and time
I am moving this to a more appropriate forum. The Member Introductions forum is not for technical questions.
Re: getting NaN/NaN/0NaN value instead of Date and time
Also, please don't spam post multiple copies of the same question. I've deleted your duplicate thread.
Re: getting NaN/NaN/0NaN value instead of Date and time
Hi,
Thank you. Actually iam very new to this. and also i have some English problem please help me if i do any mistakes