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…
I have SQLite DB one table contains datetime field with datatype "timestamp" REAL value is 18696.0 attach image for table structure So, I want this 18696.0 value to be converted into MySQL Y-m-d format and result should be 2021-03-10 I…
Sorry if its a very basic question but I dont understand the following: When I format the Date object (no matter what library I used), I get a string. from this: 2022-11-28T16:55:44.000Z (new Date object) I get this: 2022-11-28 16:55:44…
I want to get closest date from $search_date if is not same values in $array['date']. If is same value in $array['date'] I want all array. Format date is 'Y-m-d'. Example 1: $search_date = '2022-12-08'; $array = [{"price":"200","date":"2022-12-12"},{"price":"50","date":"2022-12-10"},{"price":"100","date":"2022-12-10"}] Return should be:…
I`ve got code that shows all of the placements for a user. Is there a way to narrow this down to only show placements that are in the future? I've tried to do this using where and carbon::now to no…
Hello i want to compare dates in laravel please tell me this code is right. I want to check it before login. When user is registered, user must be deactivated Admin must activate the user: end_date=activated_date +90 days Admin Deactivation…
I have this date format : YYYY-MM-DD (example : 2022-05-10) I want to extract only last 6 months inclunding current months. The result normaly it's : june, july,august, september, octobre, november (6 last months) I do this request : Select…