Working with Data datatype

[kadari]

Hi,
I've two date attributes start_date and end_date.I want to retrieve dates of all sundays happening between these two dates.How to do this ?Any idea ?

TIA,
Kadari.

[tamilselvan]

Where are the data stored?

[kadari]

Hi,
Data is stored in a table called Flight.In this one I've columns like,Id,start_date,end_date ,etc. Now I need to retrieve all the sundays happening between these dates.Not only sundays,actually I've other attributes called operating_sun,operating_mon,etc.I've to find out which of the attribute value is true and for that day I've to find out all the days between start and end dates.

Thanks,
Kavitha.