On May 17, 6:29 am, badnaam <[email protected]> wrote: > I am storying a column called start time and endtime, both having > mysql type "time". >
[snip] > > The time gets stored just fine (though in 24 hour format, which is > another headache), but when I extract this time to compare it to > Time.now, to figure out, if "now" is between end and start time, the > time returned is something like Sat Jan 01 15:00:00 UTC 2000, which is > nowhere in 2010. > > Why is this happening? Whats the best way to store start and end time > to compare later on with "now". The mysql time type is a pure time of day type (ie no date component). You want a datetime column. Fred -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
