Tuesday, August 14, 2007

Show mysql timestamp/datetime column with AM and PM in JSP/JAVA


How to show mysql timestamp/datetime column with AM and PM in JSP/JAVA

<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date.*" %>
<%@ page import="java.util.Calendar" %>
<%@ page import="java.util.GregorianCalendar" %>
<%@ page import="java.text.*" %>


SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date date = format.parse(rs.getString("entry_date_time"));
GregorianCalendar calendar = new GregorianCalendar();
calendar.setTime(date);
out.print(calendar.get(Calendar.DATE)+"/");
out.print((calendar.get(Calendar.MONTH)+1)+"/");
out.print(calendar.get(Calendar.YEAR)+"&nbsp;&nbsp;&nbsp;");
out.print(calendar.get(Calendar.HOUR)+":");
out.print(calendar.get(Calendar.MINUTE)+":");   
out.print(calendar.get(Calendar.SECOND));       
if(calendar.get(Calendar.AM_PM)==0) out.print("AM"); else out.print("PM");