What is they query format for date in Postgres?

Question

I'm new to SQL. I made an SQL query, but I do not know a correct date format that I wish to use. I have syntax errors, that I can't show right now. Thanks very much for any assistance.

const getWhere = () => {
  const whereCondition = `"Report"."statusId" IN (${statusIds})
  ${params.startDate ? `AND "Report"."createdAt" >= DATE(${moment(params.startDate).format('YYYY-MM-DD')})` : ''}
  ${params.endDate ? `AND "Report"."createdAt" <= DATE(${moment(params.endDate).format('YYYY-MM-DD')})` : ''}`
  return whereCondition;
}

Tag your question properly that community can find it. It looks like Javascript to me, so I will add a temprorary tag. — jorge is not ai
– jorge is not ai, Commented Mar 31, 2020 at 19:52
Also you should add expected date format. From the code you've posted it is not clear of what you are trying to achive. — jorge is not ai
– jorge is not ai, Commented Mar 31, 2020 at 19:57

Laurenz Albe · Accepted Answer · 2020-03-31 20:07:38Z

1

The ISO format (YYYY-MM-DD) is fine.

But the date literal must be a string, that is, surrounded by single quotes (').

answered Mar 31, 2020 at 20:07

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

What is they query format for date in Postgres?

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