Skip to content

Instantly share code, notes, and snippets.

@regedarek
Created February 8, 2013 19:55
Show Gist options
  • Select an option

  • Save regedarek/4741515 to your computer and use it in GitHub Desktop.

Select an option

Save regedarek/4741515 to your computer and use it in GitHub Desktop.
>> Job.where("application_date = ?", Job.last.application_date)
Job Load (0.2ms) SELECT "jobs".* FROM "jobs" ORDER BY created_at ASC LIMIT 1
Job Load (0.2ms) SELECT "jobs".* FROM "jobs" WHERE (application_date = '2013-02-13') ORDER BY created_at DESC
=> []
@regedarek
Copy link
Copy Markdown
Author

Schema jobs:
#  application_date       :date

@regedarek
Copy link
Copy Markdown
Author

>> Job.where(application_date: (Date.today + 5.days).strftime)
  Job Load (0.1ms)  SELECT "jobs".* FROM "jobs" WHERE "jobs"."application_date" = '2013-02-13' ORDER BY created_at DESC
=> []
>> Job.last.application_date
  Job Load (0.7ms)  SELECT "jobs".* FROM "jobs" ORDER BY created_at ASC LIMIT 1
=> Wed, 13 Feb 2013

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment