We have a lot of data with a lot of events with a lot of dates in a MySQL db. Generating lists of e.g. events per year, or students per year, is fairly simple. Now, we've decided to change everything…
When I select all columns, the indexing does not work, but if I select just a few columns, it does. mysql> explain SELECT * FROM fatura USE INDEX (datapago_serv_pago) WHERE id_servidor = 10 AND pago = '1' AND data_pago <=…
How can I get the string dd.mm.yyyy in JavaScript and convert it depending on the user's locale (for example, дд.мм.гггг)? Is it possible with the help of internal functions, or will you have to write your own converter? I tried…
I am populating an array of dates from two sources: an array of dates and a range of dates between two dates. $dateann = ['2024-08-16', '2024-08-11', '2024-08-16', '2024-09-16']; $period = CarbonPeriod::between('2024-08-01', '2024-08-31'); foreach ($period as $date) { $days[] = $date->format('Y-m-d');…
Edit: My local timezone is UTC+1 I have this date string: 2024-07-01T00:00:00.000Z. This date string has a 'Z' at the end which denotes that it is in UTC (If I understand correctly). When I run moment('2024-07-01T00:00:00.000Z').toISOString() -> '2024-07-01T00:00:00.000Z' // returns…
I am pre-selecting a date on <input type='date' /> and want the user to select a date anyway. If the date selected is the same as the pre-selected value, it does not trigger the change event in jQuery. Also tried…
I am working on a transaction dataset with one date column & one identifier column. Now retroactively I want to create a boolean column to check whether any particular activity (e.g. marketing campaign) should have been sent for that identifier…
I have 2 dates in ISO string format. I mean 2024-07-25T00:58:00.000Z and 2024-07-30T13:35:00.000Z. I am trying to make them combine as 2024-07-25T13:35:00.000Z. Is there a way to do this with a simple solution?
I have this code which shows the year in YYYYMMDD format. I would like the output to be in YYMMDD format. Basically to replace 2014 to 14 only. let date = new Date(); let timeNow = new Date(date.valueOf()-60*1000*date.getTimezoneOffset()).toISOString().substring(0, 10).replace(/-/g,""); console.log(timeNow);…
I am trying to generate a sequence of dates. However, when generating JS, it constantly misses October 29, 2023. Could someone explain what could be the reason? In this post someone noted that on this day there is a transition…