How to get the missing date and day in a table?

Shell Programming and Scripting
1

Hi Am using unix Aix Ksh
Have Created table called vv
and i have inserted two date

Select * from vv;
 
Output :-
 
New_date
21/02/2013
24/02/2013

I have tried Using One query but Unsuccessful so far..

 
SELECT l.new_date + '1 day' as miss
from vv as l
left outer join vv as r
on l.new_date + '1 day' = r.new_date
where r.new_date is null

When i tried running the above query am getting the output as

miss
 
22/02/2013
25/02/2013

i need the results as

miss
22/02/2013 , fri
23/02/2013.  sat
24/02/2013 , sun
 
 
or atleast
fri
sat
sun

Can anyone help me pls ....

2

Did you even try my suggestion posted in your previous thread

3

bipinajith ,

The to_char and to_date function was not working in unix Aix Ksh version 5.

4

Forget about AIX & KSH. Tell us which database are you using?

5

Hi bipinajith ,
Am using isql DB on unix Server...

6

AFAIK isql is just an interface or utility used to connect to a DB & execute queries and to_char and to_date are standard SQL functions.

7

bipinajith ,

Using Ingres DB..

8

OK, I am not familiar with Ingres DB so I looked at the Ingres knowledge base to understand what date functions are available and I'm not sure if any of these functions will help achieve what you are trying to do.

So I suggest you to do this part outside DB. Here is a thread that might help you.