Can not send data to table MariaDB, please help

General
21

I try to deliver the timestap in a way that the MariaDB accepts.

I can simulate an inject with the app HeidiSQL and this is what I got back:

INSERT INTO digitalempire.meterdata (client, project, meter_id, date, value) VALUES ('client7', 'project7', 'meter_id7', '2020-08-09 17:37:37', '7');

So this is the reason I om chopping the timestamp into bits and pieces and then shuffle them in a way that works.

I hope I make sense :slight_smile:

22

Are you trying to write the current time? If so then use a Timestamp column and tell it to automatically insert the current time for you, DEFAULT CURRENT_TIMESTAMP. Then you don't have to do anything.

23

Thank you all very much!

My issues are completely resolved.