Marnen Laibow-Koser wrote:
> Newb Newb wrote:
> [...]
>> hi all..
>> i want to ask one more help...
>>
>> d0_time = d0.strftime("%I:%M %p")
>> d1_time = d1.strftime("%I:%M %p")
>>
>> 12:00 am
>> 07:00 pm
>> i get two times here.i ll take the above times as from and to.
>> i have time as field into my table.it stores like 01:17:56 am.
>
> Are you storing the time as a string in the DB? If so, don't. Store
> times as time or datetime.
>
>>
>>
>> i want to fetch the records which is between the above two times ..
>> how can i implement the query
>
> SELECT * FROM table
> WHERE hour(time) BETWEEN 0 and 19
>>
>> pls suggest me
>
> Best,
> --
> Marnen Laibow-Koser
> http://www.marnen.org
> [email protected]
hi..
i m using date picker like below
<%= calendar_date_select_tag "e_date[]", Date.today, :popup => :force
,:time => true %>
is it possible to disable the dates ...
i want to able to select only time...
is it possible...
thanks in advance
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
