Find Current Month ?

37 views
Skip to first unread message

Maddy

unread,
Jan 24, 2013, 7:24:52 AM1/24/13
to rubyonra...@googlegroups.com
HI Folks,

How to find current month?
and
How to collect current month data from our database?

Please advice.

Thank You.

Jordon Bedwell

unread,
Jan 24, 2013, 7:31:33 AM1/24/13
to rubyonra...@googlegroups.com
On Thu, Jan 24, 2013 at 6:24 AM, Maddy <ashok...@shriramits.com> wrote:
> How to find current month?
> and
> How to collect current month data from our database?

I'm not trying to be a dick, but these are fundamental tasks that you
should have learned first.

[1] pry(main)> Time.new.strftime("%B") #=> "January"
[2] pry(main)> Time.new.strftime("%b") #=> "Jan"
[3] pry(main)> Time.new.month #=> 1

As for the latter, that's a hard question to ask, because I would not
query by date the Rails way, I would opt to use PG functions to format
the date and query that way so without knowing a database I cannot
help there but it's not hard to use where("created_at >= ?",
5.days.ago) though I don't even know if that's a good way to do it in
Rails because again I would never do date queries directly in Rails.
Reply all
Reply to author
Forward
0 new messages