Re: date question

"Don't listen to anybody"?? Interesting choice of words. Of course you can change your NLS formats. However...

It has nothing to do with "not [being] sure". It's just plain sense, if you want to pull up all the appropriate records rather than relying on the assumption that you'll get all the rows you need 'cuz they're all in the format that is set by NLS -- then you use the TO_DATE function.

If I have misunderstood the intent of your reply, accept my apologies.

Cheers,

Bricklen

Alex Filonov wrote:
>
> Helen Pai <hpya78_at_postoffice.pacbell.net> wrote in message news:<3CA6206C.D7F8CC05_at_postoffice.pacbell.net>...
> > Hello,
> >
> > why my hiredate didn't show anything?
> >
> >
> > SQL> select ename, job, hiredate
> > 2 from emp
> > 3 where hiredate between '20-FEB-81' and '01-MAY-81';
> >
> > no rows selected
>
> Don't listen to anybody. Check how is environment variable
> NLS_DATE_FORMAT set. It should be DD-MON-RR for your statement to work
> right. If not sure, use to_date function with above mentioned format
> mask.
Received on Tue Apr 02 2002 - 14:36:17 CST