PostgreSQL double colon to Sequelize query

Question

select column_name::date, count(*) from table_name group by column_name::date

What is the equivalent of this SQL query in Sequelize? I couldn't find what to do when there is "double colon" in PostgreSQL query.

It's a type cast. In standard (ANSI) SQL it would be cast(column_name as date) — user330315
– user330315, Commented Mar 10, 2022 at 15:22

yalin · Accepted Answer · 2022-03-10 17:20:02Z

1

Thanks to a_horse_with_no_name comment I decide to use;

sequelize.literal("cast(time_column_name as date)")

with the grouping section and the latest code take form;

ModelName.findAndCountAll({
  attributes: [
    [sequelize.literal("cast(time_column_name as date)"), "time_column_name"],
  ],
  group: sequelize.literal("cast(time_column_name as date)"),
})

So, it gives two SQL query (because of findAndCountAll() function);

SELECT count(*) AS "count"
FROM "table_name"
GROUP BY cast(time_column_name as date);

AND

SELECT cast(time_column_name as date) AS "time_column_name"
FROM "table_name"
GROUP BY cast(time_column_name as date);

answered Mar 10, 2022 at 17:20

yalin

1233 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL double colon to Sequelize query

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