Postgres 'to_char' in Sequel

Question

I'm writing a Sinatra API using Sequel, but I don't know how to translate some of my postgres queries into Sequel. My table has a date column and I want to graph records grouped by year-month, so I have the following SQL:

year_months_sql = "select distinct to_char(date, 'YYYY-MM') as year_month
from receipts
where date >= ?
order by year_month asc"

This is one of a few queries that uses this to_char(date, 'YYYY-MM'). I can't find anything on Sequel docs about this.

sequel.jeremyevans.net/rdoc/files/doc/…

jordanm
– jordanm

2015-02-27 05:58:34 +00:00
Commented Feb 27, 2015 at 5:58 — jordanm
– jordanm, Commented Feb 27, 2015 at 5:58

Jeremy Evans · Accepted Answer · 2015-02-27 16:22:41Z

3

to_char is an SQL function, and there are quite a few places in Sequel's documentation that discuss them, such as http://sequel.jeremyevans.net/rdoc/files/doc/sql_rdoc.html#label-Functions

Here's a translation of your SQL to Sequel's DSL:

DB[:receipts].
  distinct.
  select{to_char(:date, 'YYYY-MM').as(:year_month)}.
  where{date >= ?}.
  order(:year_month)

answered Feb 27, 2015 at 16:22

Jeremy Evans

12.2k32 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres 'to_char' in Sequel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related