Daita
  • Introduction
  • Getting started
  • Usage
    • relational
      • SELECT
      • INSERT
      • UPDATE
      • DELETE
      • Schema
        • CREATE SCHEMA
      • Table
        • CREATE TABLE
        • ALTER TABLE
        • DROP TABLE
        • LOCK TABLE
      • View
        • CREATE VIEW
        • DROP VIEW
      • Index
        • CREATE INDEX
        • DROP INDEX
      • Functions
        • Aggregation
          • AVG
          • COUNT
          • MAX
          • MIN
          • SUM
        • Conditional
          • CASE WHEN
          • COALESCE
          • GREATEST
          • LEAST
        • Date
          • DAY OF MONTH
          • DAY OF WEEK
          • DAY OF YEAR
          • HOUR
          • MINUTE
          • MONTH
          • NOW
          • SECOND
          • WEEK OF YEAR
          • YEAR
        • Numeric
          • CEIL
          • FLOOR
          • ROUND
        • String
          • CONCAT
    • ORM
    • cli
  • Adapters
    • pg-adapter
    • sqlite-adpater
    • mariadb-adpater
    • http-adpater
Powered by GitBook
On this page
  1. Usage
  2. relational
  3. Functions
  4. Date

DAY OF WEEK

const mountains = await client.select({
   select: {
       name: field(Mountain, 'name'),
       day: dayOfWeek(field(Moutain, 'firstAscentDate')),
   },
   from: table(Mountain),
});
// postgres sql: SELECT "Mountain"."name", date_part('day', "Mountain"."firstAscentDate")
//             FROM "Mountain"
//
// sqlite sql: SELECT "Mountain"."name", round(strftime('%w', "Mountain"."firstAscentDate"))
//             FROM "Mountain"
//
// const mountains: { name: string, day: number }[]
PreviousDAY OF MONTHNextDAY OF YEAR

Last updated 1 year ago