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…
I have this simple code (Xcode iOS app) import SwiftUI struct ContentView: View { var body: some View { VStack { Button(action: { let dateToday = Date() let dateOneYearAgo = Calendar.current.date(byAdding: .year, value: -1, to: dateToday) ?? dateToday print("dateToday: (dateToday)…
SELECT date_format(CURDATE(), '%e-%b-%y'); This spits out the date to be 27-Dec-22 and I simply need to run another query so it shows 27-Dec-23
I have two dates, e.g. '2022-01-03' and '2022-03-04', is there any neat way to calculate ONLY the completed full calendar months between these dates? Some examples with their requested outputs: '2022-01-03' and '2022-03-04' full calendar months = 1 since only…
I have a code in PHP 5.5.11 where I am trying to do the following: Get today's date in a variable --> $today Calculate the end of month from a date in a form --> $st_dt_eom if difference between these…
I just discovered, that storing dates in utc is not ideally correct if we are also dealing with dates in the future. It seems to be the case because, timezones seem to change more often than we think they do.…
I'm really struggling with dates and timezones. My understanding is Date is independent of timezone and is just a point in time. I'm writing a unit test and I want to create a Date object that would represent the time…