How to format date?

I tried:

  const allPosts = db
    .select({
      ...getTableColumns(posts),
      formatted: sql<string>`to_char(created_at, 'Mon DD, YYYY')`,
    })
    .from(posts);

  const allPosts = db
    .select({
      ...getTableColumns(posts),
      formatted: sql<string>`to_char(created_at, 'Mon DD, YYYY')`,
    })
    .from(posts);

but it does not return an array of objects. How do I get an array of objects from the above query? Similar to what this statement returns:

const allPosts = await db.select().from(posts); // returns {title:string...}[]

const allPosts = await db.select().from(posts); // returns {title:string...}[]

7 Replies

Sillvva•12mo ago

You might need to cast created_at as a timestamp.

  const allPosts = db
    .select({
      ...getTableColumns(posts),
      formatted: sql<string>`to_char(`${posts.created_at}::timestamp, 'Mon DD, YYYY')`,
    })
    .from(posts);

  const allPosts = db
    .select({
      ...getTableColumns(posts),
      formatted: sql<string>`to_char(`${posts.created_at}::timestamp, 'Mon DD, YYYY')`,
    })
    .from(posts);