|
|
|
|
|
|
|
Re: Can we find date/dates based on ..... ? [message #286936 is a reply to message #286932] |
Mon, 10 December 2007 09:16   |
thisisnatesh
Messages: 92 Registered: March 2007
|
Member |
|
|
Hi Mic
I got the solution from this query. 
SELECT date_val
FROM (SELECT (SELECT TRUNC (TO_DATE ('08', 'yy'), 'yy')
FROM DUAL)
- 1
+ ROWNUM "DATE_VAL"
FROM all_objects
WHERE ROWNUM <=
( (SELECT LAST_DAY (TRUNC (TO_DATE ('08', 'yy'), 'yy')
+ 363)
FROM DUAL)
- (SELECT TRUNC (TO_DATE ('08', 'yy'), 'yy')
FROM DUAL)
+ 1
))
WHERE TO_CHAR (date_val, 'w') = 2
AND TO_CHAR (date_val, 'mm') = 10
AND TO_CHAR (date_val, 'DY') = 'TUE'
Can we do it more better than this? Thanks Mic.
You are in my every solution.
Regards
Natesh
[Updated on: Mon, 10 December 2007 09:17] Report message to a moderator
|
|
|
|
|
|
Re: Can we find date/dates based on ..... ? [message #286941 is a reply to message #286911] |
Mon, 10 December 2007 10:05   |
 |
rajavu1
Messages: 1574 Registered: May 2005 Location: Bangalore , India
|
Senior Member |

|
|
OR one different version like
SQL> WITH PARAMSET AS (SELECT &Y Y, &M M, &W W ,'&d' DY FROM DUAL )
2 SELECT NEXT_DAY (ADD_MONTHS(TRUNC (TO_DATE ( Y, 'yy'), 'yy'),M-1)
3 + (W-1)*7 ,DY )
4 FROM PARAMSET;
Enter value for y: 07
Enter value for m: 12
Enter value for w: 2
Enter value for d: TUE
old 1: WITH PARAMSET AS (SELECT &Y Y, &M M, &W W ,'&d' DY FROM DUAL )
new 1: WITH PARAMSET AS (SELECT 07 Y, 12 M, 2 W ,'TUE' DY FROM DUAL )
NEXT_DAY(
---------
11-DEC-07
SQL>
But this is a small start , byt needs some changes ..

Rajuvan.
[Updated on: Mon, 10 December 2007 10:08] Report message to a moderator
|
|
|
|