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]
--
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
-~----------~----~----~----~------~----~------~--~---
