That works great. Thank you!
On Saturday, January 26, 2013 12:21:07 PM UTC-5, Jeremy Evans wrote:
>
> On Saturday, January 26, 2013 8:50:13 AM UTC-8, Adam Gotterer wrote:
>
>> How can I find the difference between two times and extract the hours
>> between them? I was able to do it with a literal, but I was wondering if
>> there was a better way.
>>
>> select('date1 - date2'.lit.extract(:hour))
>>
>
> You can currently do:
>
> Sequel.extract(:hour, :date1 - :date2)
>
> By default, the following does not work:
>
> (:date1 - :date2).extract(:hour)
>
> But you can make it work by doing:
>
> Sequel::SQL::NumericExpression.send(:include,
> Sequel::SQL::ComplexExpressionMethods)
>
> Thanks,
> Jeremy
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/sequel-talk?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.