Re: Oracle nls_date_format

Hello,

no oracle experts out there?

Anyway I've played a little with java and wrote a script to see wether it's a 
JDBC or SQuirreL problem. 

import java.sql.*;
class dbAccess {
  public static void main (String args []) throws SQLException
  {
        DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
        Connection conn = DriverManager.getConnection 
("jdbc:oracle:thin:@XXXX", "xxxxxx", "xxxxx");
        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select sysdate from dual");
        rset.next();
        System.out.println (rset.getString(1));
        stmt.close();
  }
}

$ java -Doracle.net.tns_admin=$ORACLE_HOME/network/admin -classpath 
$ORACLE_HOME/jdbc/lib/ojdbc14.jar:./ dbAccess
2007-10-19 08:57:53.0

As you can see the JDBC driver gives me the correct date format. I don't even 
have to set the NLS_DATE_FORMAT.

SQuirreL shows me only the date "2007-10-19". But I'm missing the time.

Please, any help would be appreciated to get rid of these to_char() stuff.

Frank


Am Freitag, 28. September 2007 09:00:18 schrieben Sie:
> Hi list,
>
>  I can't set the nls_date_format within an oracle session.
>  I've tried to start SQuirreL with the environment
> NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss' and with the java options
> '-Duser.language=de -Duser.country=DE'. Even 'alter session set
> nls_date_format='yyyy-mm-dd hh24:mi:ss' doesn't work.
>
>  Does anybody have an idea?
>
>  Regards
>  Frank
>
>  -------------------------------------------------------------------------
>  This SF.net email is sponsored by: Microsoft
>  Defy all challenges. Microsoft(R) Visual Studio 2005.
>  http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>  _______________________________________________
>  Squirrel-sql-users mailing list
>  Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
>  https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/