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.

24

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.