On Tuesday, October 3, 2017 at 3:40:00 PM UTC-7, Grant Schoep wrote:
>
> One more question. Looking through the examples I didn't see this. Does
> Sequel gem support the BETWEEN funciton in sql. Example below
>
> SELECT id FROM my_metadata WHERE ('2013-06-21T19:24:59.421111Z' BETWEEN
> datastarttime AND datastoptime);
>
DB[:my_metadata].select(:id).where('2013-06-21T19:24:59.421111Z'=>:datastarttime..:datastoptime)
Technically, this uses >= and <= and not BETWEEN, but the result is the
same and it should result in an identical execution plan on most databases.
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
