Fetching date in mysql is returning previous day's date

44
October 21, 2021, at 3:10 PM

I have data in a particular table in mysql. The date of the last entry (number 314) in the table is 18-10-2021 (but in yyyy-mm-dd format). I am using a get request to fetch the data in the table, reverse the order and print it in the console. The value in the console is the previous day from the one in the record. How can I fix this issue?

Date: "2021-10-19T18:30:00.000Z"
Date_Format: "19-10-2021"
Defaulter: 0
Description: "Testin date"
Hours: 5
ID: 13009
Project: "StrikeTru"
Resource: "Lekha"
Role: "Developer"
S_No: 320
S_No_Format: 240

0

Here is the details of mysql session.

select @@sql_mode;

result :

STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO
READ ALSO
Facing Issue On Opencart With Ccavenue Payment gateway securtiy Error

Facing Issue On Opencart With Ccavenue Payment gateway securtiy Error

i am faicng a issue on my website when i try to buy something from website the payment is deducted from website but order is not place and also getting a error like "Ccavenue mcpg payment order transaction has been declined due to security errorIllegal...

57
How to rearrange objects in arraylist based on card type [duplicate]

How to rearrange objects in arraylist based on card type [duplicate]

I have a scenario where I have to rearrange the elements of bank name in a particular orderThis list can be in any order [Wellsfargo, Bank of America, Chase, Citi, American Express] and may not have one or more of the banks in the list

58
useSWRInfinite - getKey function always gets pageIndex as 1

useSWRInfinite - getKey function always gets pageIndex as 1

I am using the SWRInfinite example as defined here (https://githubcom/vercel/swr/discussions/732) and here (https://swr

45