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