My co-worker and I were debugging an issue when we came across something curious: the same bit of VB code produces a different output on my machine versus his. We cannot figure out why. The code: Dim textForMatching = unmatchedRecord.MetaDataString…
I am trying to write an application for booking a time slot at an airfield, basically there is an open and close period and time interval, the application then loops between the two time values and displays a select dropdown.…
i'm trying to convert gen. 02, 2023 date in 2023-01-02 but my function formatDate: function formatDate(date) { var d = new Date(date), month = '' + (d.getMonth() + 1), day = '' + d.getDate(), year = d.getFullYear(); if (month.length <…
How to get localized short names of the days of week starting from monday to sunday in javascript?
I have a MySQL database which holds one column years_valid_for as bigint and another column completion_date as datetime(6). I have to subtract bigint columns number as years. e.g. years_valid_for is 4 and completion_date is 2023-06-07. I have to subtract 4…
DATE ACCOUNT VALUE 2023-06-06 1234 100 2023-06-07 1234 120 2023-06-08 1234 80 2023-06-06 3456 40 2023-06-07 3456 60 2023-06-08 3456 80 2023-06-05 5648 600 2023-06-06 5648 800 2023-06-06 5648 650 2023-06-07 5648 0 2023-06-08 5648 0 I'm passing current date…
I have a car model and an order model, i need a query that will filter the list of cars that are not rented between two dates, i'm lacking the logic to get the answer right what i came up…
I want to show "The last days of the offer" for example: Offer days: 1, 2 and 3 of June 2023. My code works fine, until I get to the start of a new month. At the beginning of each…
$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…
CREATE TABLE table (`id` int, `date` date, `time` time); INSERT INTO table (`id`, `date`, `time`) VALUES (1, '2022-05-22', 14:00:00), (2, '2022-05-23', 07:35:00), (4, '2022-05-23', 14:00:00); Expected Output: date time 2022-05-22 14:00:00 2022-05-22 NULL 2022-05-23 07:35:00 2022-05-23 14:00:00 As you notice,…