Re: Server and Client SQL statements work differently?

Try...

SELECT * FROM psms_db.down_hist WHERE datestamp > to_date('06-Aug-1998 00:00:00', 'DD-Mon-YYYY HH24:MI:SS')

Or alter your session with

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-Mon-YYYY HH24:MI:SS';

--
Thanks,
Biju Thomas

For Oracle Scripts, Tips and Links
http://www.geocities.com/SiliconValley/Peaks/4535/oracle_main.htm Received on Thu Aug 06 1998 - 23:02:42 CDT