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: date retrieval

Re: date retrieval

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 19 Oct 2006 12:36:43 -0700
Message-ID: <1161286603.313275@bubbleator.drizzle.com>


frank_at_webtecsinc.com wrote:

> Thank you for the reply.  However, that just returns 5, for Thursday.
> 
> DA Morgan wrote:

>> frank_at_webtecsinc.com wrote:
>>> How would I go about retrieving all Friday and Saturday dates between
>>> two dates, say 5/1/06 and 11/1/06?
>> By using TO_CHAR in the following fashion:
>>
>> SELECT TO_CHAR(SYSDATE, 'D') FROM dual;
>>
>> and filter for the values 6 or 7.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

Of course it does ... today IS thursday.

Perhaps this demo would have been better for you:

SELECT TO_CHAR(created, 'D') FROM all_objects;

Do you know how to write a WHERE clause?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Oct 19 2006 - 14:36:43 CDT

Original text of this message

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