Date_time column in where between date1 and date2 #365
-
How to select using where query for two dates |
Beta Was this translation helpful? Give feedback.
Answered by
ujjwalguptaofficial
May 20, 2024
Replies: 2 comments
-
Hi You need to pass date object in the column value like this -
|
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
ujjwalguptaofficial
-
Added docs for date data type - https://jsstore.net/docs/where/date |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi
You need to pass date object in the column value like this -
https://ujjwalguptaofficial.github.io/idbstudio/?db=Demo&query=select(%7B%0A%20%20%20%20from%3A%20%22Orders%22%2C%0A%20%20%20%20where%3A%20%7B%0A%20%20%20%20%20%20%20%20orderDate%3A%20new%20Date(%221996-07-04T00%3A00%3A00.000Z%22)%0A%20%20%20%20%7D%0A%7D)%3B