[Rails] problem on subtract one year from current year in ruby on rails

On 12 December 2011 10:36, amvis wrote:
For the ruby on rails application. i have to generate last one year report.

my question is how to subtract one year from current date in ruby, basically
the format of date in MySql is YYYY-MM-DD. so how to subtract one year from
this.

i tried one..

time = Time.new
puts ddat = time.strftime("%d-%m-%Y")

On Mon, Dec 12, 2011 at 6:42 PM, Michael Pavling wrote:
last_year = Time.now.ago(1.year)

records = MyModel.all(:conditions => ["my_date_field > ?", last_year])

Have a look at the api commands around dates and times:
http://api.rubyonrails.org/classes/Time.html

--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On Dec 12, 4:56 pm, amvis wrote:
in my machine i dn't have the local application setup. so just i try this
two for display  that

*puts last_year = Time.now.ago(1.year)  *or*  last_year = 1.year.ago*

but it gives error  *undefined method `year' for 1:Fixnum (NoMethodError).*year is  builtin...?

On Tue, Dec 13, 2011 at 11:03 AM, amvis wrote:

* last_year* = 1.year.ago

SELECT count(id) from customers where created_at > *"2010-12-13"*

In the above query i need to change into a variable* last_year instead of
"2010-12-13" *. and how to convert this MySQL query into rails query.
also give me a link to study the rails queries

Thank you
vishnu


--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/cnYC3lpN4a4J.

To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On 13 Dec 2011 08:08, "amvis" wrote:
any idea to select that? i have to fetch the data in each month from