NLS_DATE_FORMAT and Stored Proc

From: swatir <swatir_2003_at_yahoo.com>
Date: 1 Nov 2004 14:00:01 -0800
Message-ID: <ea944b33.0411011400.37e96c9f@posting.google.com>

Hi,

I am sending a date time as a string to a stored proc. The stored proc compares this date time value to the date time value in a column in the DB. This comparison is failing due to the formats of the date time. The string I am sending in is of this format - "01/01/1976 12:30:00".

I also have an entry in my .bashrc -
export NLS_DATE_FORMAT="mm/dd/yyyy hh24:mi:ss".

The stored proc however reads the date time value from the column in the oracle default format "DD-MON-YY" and fails on the comparison.

Any help is appreciated. Received on Mon Nov 01 2004 - 16:00:01 CST