> > 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
