I have small problem in app. Backend is Laravel and Front end is Nuxtjs. When User registered on app,then users must be wait antill Administartor approved. When Admin approved this user we give them 3 months subscription. In my code…
i have some records on mysql db, i tried to group by month, data is correct but time of March month is showing as "2022-03-22", i required as same as other months like 2022-03-01. time month_name inc_number 2022-01-04 19:58:09 January…
I'm triying to add quantities of fuels from two tables. Payments table contains data about customers and dates. Fuels table contains data about fuels recharged. I need to add the litres by customer in 3 groups: from yesterday until 46…
I'm starting to learn MongoDB, and I love how flexible it is. But I'm stuck on a query, and I would like to know the solution. I have a collection that goes like this: { "_id" : ObjectId("633e08f5edef7d5ffc6d0583"), "etiquetaPrincipal" :…
i have one column (vedu_time) in "YYYY-MM-DD HH:MM:SS" format, i required new column (ganta_time)(new) having only HH:MM:SS for all my records at a time. Please suggest the query. vedu_time | ganta_time --> New column --------------------|------------ 2021-12-01 07:12:30 | 07:12:30 2021-12-01…
How to get the last seven days, from today, (by names) in java script. like if today is Wednesday, I want to get it like (Wednesday, Tuesday, Monday, Sunday, Saturday, Friday, Thursday, Wednesday).
I have date string like this '2021-03-09' And my mongodb collection like this { "_id": { "$oid": "633aede250625c10dddfd57b" }, "title": "test 1", "description": "Hello World", "date": { "$date": "2021-03-09T18:30:00.000Z" }, "image": "fd16b297-9ad1-4e84-8c3e-715a33b351b3.png", "createdAt": { "$date": "2022-10-03T14:12:50.399Z" }, "updatedAt": { "$date":…
I need to set an user meta field in user meta table of wordpress. This field will contain a date, that will be set at the fisrt login of the user otherwise the field when the user register will be…
I want to convert this date-time string 2022-09-30T21:39:25.220185674Z to yyyy-mm-dd hh:mm:ss but it returns 1970-01-01 01:00:00 everytime. Tried with: date('Y-m-d H:i:s', strtotime('2022-09-30T21:39:25.220185674Z')); or date('Y-m-dTH:i:s', strtotime('2022-09-30T21:39:25.220185674Z')); Can you help find out which format this is and how i could corretly format…
I would like to format "regDate" to 'dd/mm/YYYY' from 'YYYY/mm/dd'. Appreciate any help. Thanks. if ($request->keyword != "") { $students = Student::where ("name","LIKE","%" . $request->keyword . "%") ->orWhere("nric","LIKE","%" . $request->keyword . "%") ->orWhere("address","LIKE","%" . $request->keyword . "%") ->orWhere("telNo","LIKE","%" . $request->keyword…