I'm trying to query for users with birthdays falling between a given date range. The users table stores birthdays in a pair of int columns: dob_month (1 to 12) and dob_day (1 to 31). The date range I'm querying with…
I'm having great difficulty writing this query and cannot find any answers online which could be applied to my problem. I have a couple of tables which looks similar to the below with. Each purchase date corresponds with an item…
I'm trying to do an action when the date today (via Node.js) and the date value (via MongoDB) is the same. However, I'm not receiving any output from my for loop indicating that there's no match. Here's how I get…
I am trying to use the date() function as an alternative to the now deprecated strftime() function, and I need to know whether the date() function formats the time like the strftime() function according to the locale time. strftime() As…
I am trying to make a calendar app that can be used on iPhone. I am using SwiftUI for the app and FirebaseFirestore as my database. What I am trying to do is to make a document in Firestore inside…
I need to do a SUM of the last value (by date) of each day of the current week. To test I have a table with the values: 5 for 2023-01-12 16:53:01 2 for 2023-01-12 08:49:03 5 for 2023-01-11 08:58:19…
I am trying to sort JSON objects received from an API so that the most recent datetime is shown first. But the way I am currently doing it is sorting Dec 2022 as more recent than Jan 2023. Here is…
All the "date" in my database are of the following format: 'd-m-Y' (E.g. 09-03-2022) I want have a field with input type=date, so user can modify the date. I use the following code to pull data: $date = "<input type="date"…
so I ran into this little problem and I don't know how to solve it. I have two dates, one that comes from a Python script that arrives as a String, and one that comes from a MongoDB object. I…
My target: I have a list of stock_ids and want to get the last bids (its sorted by date) only one per stock_id. For the picture, it means i want: stock_id bid 3 663.91953 1 46.44281 2 9.02798 One problem…