NLS_DATE_FORMAT in jdbc

From: CM Wong <cmwong2_at_yahoo.com>
Date: 31 May 2007 19:43:08 -0700
Message-ID: <1180494263.585976.181030@i38g2000prf.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 Thu May 31 2007 - 21:43:08 CDT