There is the repository: https://github.com/AlexWayfer/sequel-at_time_zone
But I found that PostgreSQL has `timezone(zone, timestamp)` equivalent for
`timestamp AT TIME ZONE zone` :(
On Thursday, November 9, 2017 at 10:41:35 PM UTC+3, Alexander Popov wrote:
>
> Hello!
>
> I want to make comfortable API for `SELECT "some_date" AT TIME ZONE
> "Some/Timezone"` usage.
>
> I'm thinking about creating an extension for this (I didn't found any
> existing extension/gem for this).
>
> The final usage may looks like:
>
> ```
> DB[:items].select { created_at.at_time_zone('America/New_York') }
>
> # or
>
> Sequel[:created_at].at_time_zone('America/New_York')
> ```
>
> I figured out that I need to extend `Sequel::SQL::Identifier` class (I'm
> not sure do I need to touch `Sequel::SQL::QualifiedIdentifier` too).
>
> But I didn't found any example for extending this class, only primary Ruby
> classes via monkey-patching or refinements.
>
> What do you think? And maybe this can be included into core Sequel gem?
>
> Thank you.
>
--
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.
