Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: cf query - wanting to set nls date

Re: cf query - wanting to set nls date

From: mike <hillmw_at_charter.net>
Date: 26 Jul 2005 21:35:42 -0700
Message-ID: <1122438942.670366.51730@g47g2000cwa.googlegroups.com>


I cant be doing that in my pgm, because i'd have to make a call to see what kind of field it is..... and then try to mask it.

The user will be giving me the field: mydate and a date: '7/27/2005'

So, since I can't set nls_date_format before I do this query i'll have to change the date in the javascript before I feed it to the sql.

Then I'll get the field: mydate and a date: '27-Jul-2005' and that should work fine.

Mike Received on Tue Jul 26 2005 - 23:35:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US