how to find records with date, anything like whereDate?

Question

how to find records with date, anything like whereDate?

themodernpk opened this issue 8 years ago · 3 comments

Guys,

I am storing created_at in YYYY-MM-DD HH:MM:SS format and I am receiving date in YYYY-MM-DD format. I need to run a where condition. Can you please assist me?

Thanks

Answer 1 · 2017-04-30T11:54:52.000Z

So you are not storing dates as instances of Date?

Answer 2 · 2017-05-02T07:35:17.000Z

@vadimdemedes no, I am storing it in YYYY-MM-DD HH:MM:SS format

Answer 3 · 2017-05-05T06:21:32.000Z

In that case, regex is your best bet to match the YYYY-MM-DD part.