On Thu, 14 Nov 2002 10:12:21 -0500, Kipp, James wrote: > > > > Since you mention sqlplus, I assume you are using Oracle... One > > possibility is that the NLS_DATE_FORMAT (the default format for dates) > > differs between your sqlplus and DBI sessions. > > This is interesting. I did not know NLS_DATE_FORMAT could different between > tools used to query the data. For instance, if I do : > SELECT sysdate FROM dual; in sqlplus I get: > > SYSDATE > ---------- > 11/14/2002 > ----- > > If I do it from DBI I get: > 11/14/2002 10:11:41 AM
what is the NLS_DATE_FORMAT in your initSID.ora? I assume the sqlplus is doing an alter session for some reason. I know toad by default does not do an alter session. Jacqui Jacqui Caren, Ingram Group Ltd. [EMAIL PROTECTED] ph: +44 (0) 1483 8628xx main=00 fax=01 ddi=65 http://www.ig.co.uk/ http://www.sitedirector.org/ http://www.perl.co.uk/
