similar to: created_at Column and strftime

Hi Experts I''ve a product like this ID -> 1 Name -> Xyz Price -> 30 Created_at -> 02-NOV-07 from_date = Date.new(2, 10, 07) to_date = Date.new(2, 10, 07) @product = Product.find_by_sql("select * from products where created_at between from_date and to_date") code works perfectly, buy my issue is i dont get any data. always says no record found but if i use

hi folks. i want to check if a param exists if not to set it to a default value for my date range filter. in my controller i have: @from_date = Date.strptime(params[:startdate],"%d/%m/%Y") @to_date = Date.strptime(params[:enddate],"%d/%m/%Y") @articles = @results.find(:all, :conditions => [ "created_at >= ? and created_at

Hi All, I added a column to the sessions table called "created_at" in order to allow the created time to be recorded. However, different from other Models, the column does not update automatically. Therefore, what codes should I add to update the sessions."created_at" value? It is important for avoiding hacker keeping the sessions alive. Thanks much! Arthur -- Posted via

Hi, I need to parse the rss feed and use the pubDate field to generate a field in a xml file to use as an input to simile timeline. RSS returns the pubDate as : Sun Feb 24 06:33:32 UTC 2008 But I need it as a string : "Feb 24 2008 06:33:32 PST" When I do : ... @dt=feed_item.time @dt=@dt.to_date word_date=''%b %d %Y %H:%M:%S %z'' puts @dt.strftime(word_date) ...

Hello, i want to create a multidimensional Array or Hash with group_by ''created_at''. 3 dimensions needed: myArray[week][day][data] currently i only created it with 2 dimesions: #model def self.group_per_day all.group_by{|t| t.created_at.strftime("%d. %B, %Y")}.sort #"%U" for Weeks end #controller @pdf_activities = Activity.group_per_day #view

I am trying to take the input from a field in wich the user enters a date, and formatting it to my time format if params[:gotcha] != '''' gotc = params[:date].to_a gotc.strftime("%m/%d/%y") end Yet I get this error: NoMethodError in AddController#add undefined method `strftime? for ["00000"] What''s wrong. I''m positive this method is

Hello - My model has created_at and updated_at which get set automatically, as expected, but the time is 5 hours off. For example, if I create a new record at 7:15:25 AM the created_at time shows 12:15:25. I suspect this has to do with my time zone (Eastern Time, United States). But if I do a Time.now, it shows the correct time. Does the Timestamp class use a different zone than the Time

Hi, I was wondering what happens, if I use polymorphism in combination with created_at and modified_at? Lets say I have 3 models, which all have the attributes created_at and modified_at, then how will they updated? Will changes in the child affect the "modified_at" of the parent? Will a "child.attribute_at()" yields the value of the child or the parent? Given the child,

I have a test/fixtures/users.yml like so: apa: id: 1 username: apa [...] created_at: <%=Time.now.strftime("%Y-%m-%d %H:%M:%S")%> updated_at: <%=Time.now.strftime("%Y-%m-%d %H:%M:%S")%> I don''t like how I''m repeating myself with the strftime bit. Is there some shorter Time method to format time for a (MySQL) datetime field that

Hi All, I''m a bit stumped. All I''m trying to do is format a date and I get an error. Details below. I have a partial to list all "notes" associated with a "client" with the following code. <% for note in @client.notes %> <hr /> <%=h note.note_text %> Posted on <%=h note.created_at.strftime("%I:%M") %> by <%=h

Hello, I have have written a statictics controller for one of my applications - and I want to allow users to pull out certain statistics from a certain period. In my view, I''ve added something like this: [view] <%= form_tag :action => "bu" %> <select name="bu"> <option value="04">Germany</option> </select><br>

[Couldn''t post this to the Typo forum, hope it''s Ok here :-)] Before I go off and create a Typo ticket, I''d like to know if anyone else is experiencing this and what there thoughts might be on the subject? In Typo 1055, if you use the admin interface and change the published date for an article, you will get "post not found", when you click on the article

Hello, I am running into a little issue. There is a considerable time difference between the time that the console is giving me and the time I am seeing in the created_at and updated_at column in the DB. The difference is about 5 hours. I don''t think the problem is in the DB, but I could be wrong. Am I missing something obvious? Any clues? -- You received this message because you are

I''m using Pfeed(http://github.com/parolkar/pfeed) plugin for User Activity Feeds. It creates PfeedItem model records and uses created_at field for a lot of stuff inside. Now I need to export/import those user logs. I do exporting to YAML. When I reconstruct PfeedItem AR object from YAML, it have real(old) creation time in created_at attribute. When I save this PfeedItem - there is new

First off, I''m fairly new to ruby on rails so this may appear simple but I''m just learning the ropes :) So I have a simple blog app where a post has many comments. The ''show'' view for posts renders a partial for each comment the post has. The css class of the containing div element is cycled using cycle(). The partial code is, <% div_for(comment, :class

Hi, In voicemail.conf, you can read ; Look in /usr/share/zoneinfo/ for names of timezones. ; Look at the manual page for strftime for a quick tutorial on how the ; variable substitution is done on the values below. Where can this manual page for strftime be found ? man strftime and apt-cache search strftime don't reply much ... Regards -------------- next part -------------- An HTML

R 2.6.1 on a Thinkpad T60 running up-to-date Gentoo: Despite the documentation, which says: 'strftime' is an alias for 'format.POSIXlt', and 'format.POSIXct' first converts to class '"POSIXlt"' by calling 'as.POSIXlt'. Note that only that conversion depends on the time zone. strftime fails on POSIXct objects: > foo <-

I am getting the following error when I try the following code. controller.rb def index @stats = SubscriptionPayment.stats if params[:page].blank? @subscriptions = Subscription.paginate(:include => :account, :page => params[:page], :per_page => 30, :order => ''accounts.name'') end index.html.erb <% @page_title = ''Subscriptions'' %>

Hello, I'm a little surprised about the result of strftime for my data. > str(time) chr [1:315504] "2006-01-01 00:10:00" "2006-01-01 00:20:00" "2006-01-01 00:30:00" ... > str(strftime(time,format="%Y-%m-%d %H:%M:%S")) chr [1:315504] "2006-01-01 00:00:00" "2006-01-01 00:00:00" "2006-01-01 00:00:00" ... Why

I'm trying to declare a few date-related global variables to ease my dialplan. When I declare the following in the [globals] context of extensions.conf, I get unexpected results: YEAR = ${STRFTIME(${EPOCH},,%Y)} MONTH = ${STRFTIME(${EPOCH},,%m)} DAY = ${STRFTIME(${EPOCH},,%d)} TIMESTAMP = ${STRFTIME(${EPOCH},,%Y%m%d-%H%M%S)} If I evaluate these variables in the dialplan later, using exten