Re: Question about DATE conversion in Stored Procedure

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/04/14
Message-ID: <3913a85d.25524582@netnews.worldnet.att.net>#1/1

On Thu, 13 Apr 2000 23:42:33 GMT, "John Thomas" <Sadly_Mistaken_at_potato.mindless.com> wrote:

>a) Change the NLS_DATE_FORMAT setting within the scope of my stored
>procedure

I believe that you could issue an ALTER SESSION SET NLS_DATE_FORMAT = 'xxxxx' from within your stored procedure. You would need to issue that statement using dyn sql. You should also look at the DBMS_SQL.DESCRIBE_COLUMNS procedure. You can use it to get the datatypes of the columns that you are querying. Then you can retrieve dates directly into date fields, and convert them using to_char.

regards,

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Fri Apr 14 2000 - 00:00:00 CDT