date format

[rakhi sinha]

I have stored date in oracle database in dd/mm/yy format but when i retrieved date in pdf using this code

s3=rs.getString("DATE");

,it shows date in yyyy/mm/dd format ...but i want date in pdf in dd/mm/yyyy format.

[Md. Minhajur Rahman]

If you have stored date in oracle database in dd/mm/yy format in field name suppose date in table1, when you want to retrieve the date in dd/mm/yyyy format, you can change the query as follows...

.
.//
.
Connection conn = getConnection();
ResultSet rs = null;
String sql="Select to_char(date,'dd/mm/yyyy') date from table1";
PreparedStatement pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();

String s3="";/// storing date in dd/mm/yyyy format.........
if (rs.next()) {
    s3=rs.getString("DATE");  
}
.
.

[Eshwin Sukhdeve]

use this code
DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");

String today = formatter.format(date);

System.out.println("Today : " + today);

[rakhi sinha]

Md. Minhajur Rahman wrote:If you have stored date in oracle database in dd/mm/yy format in field name suppose date in table1, when you want to retrieve the date in dd/mm/yyyy format, you can change the query as follows...

.
.//
.
Connection conn = getConnection();
ResultSet rs = null;
String sql="Select to_char(date,'dd/mm/yyyy') date from table1";
PreparedStatement pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();

String s3="";/// storing date in dd/mm/yyyy format.........
if (rs.next()) {
    s3=rs.getString("DATE");  
}
.
.

it is showing exception(document has no page) when i am doing this

show this exception

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

ExceptionConverter: java.io.IOException: The document has no pages.


root cause

java.io.IOException: The document has no pages.
com.itextpdf.text.pdf.PdfPages.writePageTree(PdfPages.java:113)
com.itextpdf.text.pdf.PdfWriter.close(PdfWriter.java:1217)
com.itextpdf.text.pdf.PdfDocument.close(PdfDocument.java:787)
com.itextpdf.text.Document.close(Document.java:420)
LoginExample.generatepdf1.doPost(generatepdf1.java:155)
LoginExample.generatepdf1.doGet(generatepdf1.java:27)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.32 logs.


--------------------------------------------------------------------------------

[Manish Sridharan]

Can you please run the select query in db first and see if it is working fine.