Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: cf query - wanting to set nls date
"mike" <hillmw_at_charter.net> wrote in
news:1122438942.670366.51730_at_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.
>
In SQL when it is given the following characters it "sees" a string:
'27-Jul-2005'
Character strings are delimited by single quote marks in SQL.
Received on Wed Jul 27 2005 - 08:19:11 CDT