Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> NLS_DATE_FORMAT in jdbc

NLS_DATE_FORMAT in jdbc

From: CM Wong <cmwong2_at_yahoo.com>
Date: 29 May 2007 20:27:54 -0700
Message-ID: <1180495674.428807.27330@g37g2000prf.googlegroups.com>


Hi,

I've seen many discussion on setting NLS_DATE_FORMAT. But when I tried to set NLS_DATE_FORMAT inside jdbc, it didn't seem to have any effect. Please see my codes below. Anyone has an idea?

Many thanks
CM

import oracle.jdbc.pool.OracleDataSource; import javax.sql.*;
import java.sql.*;
import java.text.*;

class Test
{

    public static void main(String[] args)     {

        try

{
OracleDataSource ods = new OracleDataSource(); ods.setUser("xxxxx"); ods.setPassword("xxxxx"); ods.setURL("jdbc:oracle:thin:@//myserver:1521/XE"); Connection conn = ods.getConnection(); Statement stat=conn.createStatement(); stat.execute("alter session set NLS_DATE_FORMAT='YYYY-DD-
MM HH24:MI:SS'");

            ResultSet rs=stat.executeQuery("select trade_date from indx");

            while (rs.next())
                System.out.println(rs.getObject(1));   // *** new
format not effective here ***
            stat.close();
            conn.close();
        }
        catch (SQLException ex)

{
}

    }
} Received on Tue May 29 2007 - 22:27:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US