K
Kyselydev﹫localhost

How to cast to date. eg : `DATE(created_at)`

How to write this query in kysely 
SELECT DATE(created_at) AS date, SUM(points) AS score 
FROM table 
WHERE id = '...' 
GROUP BY date 
ORDER BY date;
SELECT DATE(created_at) AS date, SUM(points) AS score 
FROM table 
WHERE id = '...' 
GROUP BY date 
ORDER BY date;
My attempt 
const result = await db
  .selectFrom('table')
  .select(({ fn }) => [
    fn.sum<number>('table.points').as('score')
  ])
  .where('id', '=', id)
  // .groupBy('created_at')
  // .orderBy('created_at')
  .execute()
const result = await db
  .selectFrom('table')
  .select(({ fn }) => [
    fn.sum<number>('table.points').as('score')
  ])
  .where('id', '=', id)
  // .groupBy('created_at')
  // .orderBy('created_at')
  .execute()
Solution
Igal
Igal•21d ago
Hey 👋 Does this work for you? 
const rows = await db
  .selectFrom("table")
  .where("id", "=", "123")
  .select((eb) => [
    eb.cast<Date | string>("created_at", "date").as("date"),
    eb.fn.sum("points").as("score"),
  ])
  .groupBy("date")
  .orderBy("date")
  .execute();
const rows = await db
  .selectFrom("table")
  .where("id", "=", "123")
  .select((eb) => [
    eb.cast<Date | string>("created_at", "date").as("date"),
    eb.fn.sum("points").as("score"),
  ])
  .groupBy("date")
  .orderBy("date")
  .execute();
https://kyse.link/TcWWP
dev﹫localhost
dev﹫localhost•21d ago
@Igal Yes, thank you!
Want results from more Discord servers?
Add your server
More Posts
transaction takes too longI have a problem with transactions. What might be the reason that db.transaction() adds more than 10Syntax error when empty array is passed to a WHERE filter (request for more readable errors)In a query like `someQuery.where("x", "in", xs)`, if `xs` is empty, then the error will be somethingDerived tables for PostgresHi, I am trying to do a bulk update like this: ``` UPDATE your_table SET someColumn = new_values.newComplex Query Builder from dynamic input - Typescript issueHi, it's me - again 🙂 I'm currently trying to migrate our current query builder. It seems that eHow to add table/column comments when creating tables?Hey, we're approaching close to 100 tables in our project. New people will be joining our founding tNeed help improving a custom helperMy dopamine with Kysely is quite high right now, so I am experimenting all sorts of things to createjsonArrayFrom with `as` not being typedI have the following query ```ts await db .selectFrom('user') .selectAll() .select((eb) How to use multiple schema definitions ( e.g. <catalog>.<schema>.<table> )Hey guys, I'm currently working on a new version for our graphql wrapper. Currently we're using kneUsing raw SQL with `or` whereI have been using the raw SQL template tag to work with certain JSON columns and wanted to add a `orCustom Plugin to transform Alias.* to "Alias.Column1", "Alias.Column2", etc.Hi everyone, in the previous question, I asked how to transform the following syntax into a new one.