Different value of date display between database and data table

Question

I have a problem with display of dates from Oracle database in a Java webapplication using a JSF datatable. The displayed date differs from the date in the database.

Here are some examples:

in oracle: 24-APR-87 display in datatable: Apr 23, 1987  
in oracle: 01-JAN-10 display in datatable: Dec 31, 2009  
in oracle: 13-MAR-89 display in datatable: Mar 12, 1989  

Here is my Java source code:

public Result getTable() {  
    try {  
        Class.forName(dbDriver);  
        con = DriverManager.getConnection(url);  
        ps = con.createStatement();  
        String query = "SELECT * from " + getTableName();  
        rs = ps.executeQuery(query);  
        return(ResultSupport.toResult(rs));  
    } catch(Exception e) { 
        return(null);
    }  
}  

What is the cause and solution for my problem?

Answer 1

Oracle stores dates using an internal format that bears no relationship to how it's formatted for display.

What you're seeing is two different date formats being used by different frontends.

To force a query to use the format of your choice, it is best to use TO_CHAR, e.g.:

SELECT TO_CHAR(mydatecolumn,'DD-MON-YYYY') FROM mytable;

Answer 2

Try using f:convertDateTime converter with the JSF output and set the correct timeZone attribute for it.
Example (edit):

<h:outputText value="#{bean.myDate}">
    <f:convertDateTime timeZone="America/Los_Angeles" type="date" pattern="MM/dd/yyyy" />
</h:outputText>