I have a postgres database, that stores some accounting data. The accounting data have a timestamp (with timezone). I would like to aggregate/group the accounting data by date. But the date should be in the user's/requested timezone not UTC. SELECT…
I have the following code which I believe should output fr_FR as the locale but for some reason is outputting en_US_POSIX (it does this on any timezone). What have I done wrong? $loc = IntlCalendar::createInstance(new DateTimeZone('Europe/Paris')); echo $loc->getLocale(Locale::VALID_LOCALE); For refs:…
I meet some JPA behavior I cannot understand. I'm saving specific dateTime ex. 2023-01-01T12:00:00Z (this is Instant) to Postgresql Timestamp without timezone. I'm reading this value and receive the same date: 2023-01-01T12:00:00Z which is expected. I change server timezone from…
This code date("H:i") return invalid hour:min for me. Current time windows server 2016 is 10:55 But date("H:i") return 11:55 !? My PHP version is 5.6.37 and install timezonedb extention but I still have this problem. I set time zone to…
In my Javascript application, I want to convert a string to an actual Date object. My string is something like this; '2023-06-16 09-25-41' Then I convert it to a Date with a desired format using moment.js library; const dateStr =…
$a = new DateTime("2023-05-31", new DateTimeZone('Europe/Rome')); $b = new DateTime("1970-05-31", new DateTimeZone('Europe/Rome')); var_dump($a->diff($b)->y); // int(52) $a = new DateTime("2023-05-30", new DateTimeZone('Europe/Rome')); $b = new DateTime("1970-05-30", new DateTimeZone('Europe/Rome')); var_dump($a->diff($b)->y); // int(53) Why in the first case the diff is 52? I…
I have a background task that I want to schedule to run once the NYSE is closed. My background scheduler (redis-rq) requires the time will be in UTC and I'm using python. The task is scheduled during the trading day,…
Background My app uses UTC as the timezone for the database, as it should. Right now all my users are local, but I will have users in many different time zones. Most things in my app are just dates, so…
I have a problem with php in converting dates between timezones. In particular using the DateTime and DateTimeZone functions I get that the current offset of America/Mexico_City is -5 hours w.r.t UTC (-18000 seconds) $dateTimeZone = new DateTimeZone('America/Mexico_City'); $date =…
We have been struggling to design a robust flow of date and time values in our app. It is a shift scheduling app with a Flutter frontend and Node.js backend with PostgreSQL database. Business logic The app allows business owners…