On Tuesday, October 3, 2017 at 1:33:55 PM UTC-6, Grant Schoep wrote:
>
> So I'm learning the DSL of sequel instead of straight sql, there is one
> thing I can't figure out.
>
> Some one else just pointed out my Yoda speak in here.
I could have just done
DB[:some_metadata].select{id}.where{somestoptime < '2017-08-02T04:34:16Z'}
Thanks
So I have a "TIMESTAMP WITH TIMEZONE" field in a table I am trying to do a
> select from
>
In sql I would just do
> select id from some_metadata where ('2017-08-02T04:34:16Z' >=
> somestoptime);
>
> However, I'm trying to figure out how to do that in the sequel DSL. I tried
>
> DB[:some_metadata].select{id}.where{'2017-08-02T04:34:16Z' >=
> somestoptime}
>
>
> But that errors with "syntax error comparison of String with
> Sequel::SQL::Identifier failed"
>
> Maybe the >=, < isn't right way to compare timestamps?
>
>
--
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.
