How to insert Datetime field while inserting int MySQL table to get required and accurate date time from direct Us API as per our Timezone (IST)

[somu22081980]

Hi All,

I have a query on Date time.

I have created a table with the following fields and types in mySQL

I have inserted the date in the table in different ways and trying to get the data from directus API, but API is returning different values everytime.

But the API is giving correct output when I insert the date from Direct us UI, other situations the date is returning by the API is not matching with the my date and time which I have given, following is the output of the direct us API for reference.

And the data inserted in the table is different for each time, the mySQL select output is as follows.

So, kindly guide us which format or function we need to use while inserting data into mySQL, to get correct output from DirectUs API.

Regards,
Somaraju