Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to formate date in where clause?
try
where drop_date = to_date(to_char(sysdate-1,'use your nls_date_format here'))
to avoid dealing with the 'time' portion of a DATE field ( Oracle DATE format is actually a DATE-TIME value)
"Maggie" <maggiezhou_at_hotmail.com> wrote:
>I tried to run a query:
>
>select a,b c
>from d_table
>where drop_date = sysdate - 1;
>
>However, I coundn't get value return even I know there are rows matched to
>the query. I understand there must some way to format date. Can anyone
>help?
>
>Thansk.
>Maggie
>
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Jun 08 2000 - 00:00:00 CDT