I am having an issue converting the ‘Issued’ value from the format given to datetime using MySQL.
Before I write a conversion I just wanted to make sure I am not overlooking something. It may be that I am using the wrong type for MySQL.
Currently I am trying to save it as a datetime variable, but that throws the following error:
SQLSTATE: Invalid datetime format:1292 Incorrect datetime value: '2020-01-28T16:59:49Z
This what ESI returns for the ‘issued’ column when requesting from marketorders:
Am I using the wrong type or do I need to write a conversion?