Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here's approximately how I'd do it (warning: type in a browser, yadda yadda):</p> <pre><code>NSDate *startDate = ...; // your start date NSDate *endDate = ...; // your end date NSDateComponents *monthDifference = [[NSDateComponents alloc] init]; NSMutableArray *dates = [NSMutableArray arrayWithObject:startDate]; NSUInteger monthOffset = 0; NSDate *nextDate = startDate; do { [dates addObject:nextDate]; [monthDifference setMonth:monthOffset++]; NSDate *d = [[NSCalendar currentCalendar] dateByAddingComponents:monthDifference toDate:startDate options:0]; nextDate = d; } while([nextDate compare:endDate] == NSOrderedAscending); </code></pre> <p>That should give you an array of <code>NSDate</code> objects representing dates that occur approximately one month apart, starting at your start date and ending at or around your end date.</p> <p>If you want to display them in a readable fashion, you'll use an <code>NSDateFormatter</code>:</p> <pre><code>NSDateFormatter *f = [[NSDateFormatter alloc] init]; [f setDateFormat:@"MMMM yyyy"]; for (NSDate *date in dates) { NSLog(@"%@", [f stringFromDate:date]); } [f release]; </code></pre> <hr> <p>When I run this on my computer, I get:</p> <pre><code>EmptyFoundation[3327:a0f] January 2010 EmptyFoundation[3327:a0f] February 2010 EmptyFoundation[3327:a0f] March 2010 EmptyFoundation[3327:a0f] April 2010 EmptyFoundation[3327:a0f] May 2010 EmptyFoundation[3327:a0f] June 2010 EmptyFoundation[3327:a0f] July 2010 EmptyFoundation[3327:a0f] August 2010 EmptyFoundation[3327:a0f] September 2010 EmptyFoundation[3327:a0f] October 2010 EmptyFoundation[3327:a0f] November 2010 EmptyFoundation[3327:a0f] December 2010 EmptyFoundation[3327:a0f] January 2011 EmptyFoundation[3327:a0f] February 2011 </code></pre> <p>This may seem kinda complex, but it has a couple advantages:</p> <ul> <li>it will work <em>regardless</em> of what calendaring system you're using. Just change the <code>[NSCalendar currentCalendar]</code> call to be a different calendar and it'll work in that one (Hebrew, Islamic, etc)</li> <li>it accounts for months with bizarre numbers of days (28 days vs 29 days, or calendars with leap months [yes they exist])</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. POHow to get name of months and years between two dates
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDave DeLong
    1. USDave DeLong
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to get name of months and years between two dates
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIf the starting day of the month is greater than the ending day of the month it looks like it would omit the last month from the list. I'd set both startDate and endDate day=1 when initializing the loop.
      singulars
      1. PO
      1. USJohn Lemberger
    2. CO@JohnLemberger: good point; yes, you should reset the day of the month.
      singulars
      1. PO
      1. USDave DeLong
    3. COThanks for the solution
      singulars
      1. PO
      1. USsandy
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload