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…
I use PostgreSQL I can run a single query per day, but it will take a long time to go through every day. The "zone" and "reader" also changes, so to run single queries every time will keep me up…
When I fetch data from my PostgreSQL database, it comes in the following format: 2022-11-30T21:00:00.000Z and it's not a string; it's in the form of a date object. The library that I'm using to work with dates is dayjs. So…
i'm having a trouble on comparing two dates in laravel. In my app i have a date field to compare: // example $order_date = Carbon::now()->format('Y-m-d') // returns "2022-11-30" $now = Carbon::now() // returns an object with date at the bottom…
I think I might have found a bug in the strtotime() function. My application uses unix timestamps to set events for certain days. I use relative time format string in conjunction with these timestamps. I made this minimal code to…