Interroga Posted November 13, 2018 Report Share Posted November 13, 2018 Hi guys, we need help for write data in SQL table , for build report. We don't be how type for use this variable. I try string (all types), but not work. In anexx my table where need write . Thanks in advance. Quote Link to comment Share on other sites More sharing options...
Swervomotor Posted December 4, 2018 Report Share Posted December 4, 2018 I'm not sure if this will help but it works to time stamp the entries in our DB. 1 Quote Link to comment Share on other sites More sharing options...
Jordy Posted July 20, 2019 Report Share Posted July 20, 2019 This will enter the date of the insert, not the date from the local datastruct. Good question because we need this also... we need a timestamp value in a locak table structure. Maybe the string format YY:MM:DD HH:MM:SS will work? Quote Link to comment Share on other sites More sharing options...
Interroga Posted July 28, 2019 Author Report Share Posted July 28, 2019 Brother, below is the answer: INSERT INTO `Alarm` \\ table adress (`DateTime`, `User`,`Event`,`Coment`) \\ column VALUES(STR_TO_DATE(@DateTime,'%d/%m/%Y %T'), @User, @Event, @Coment ) 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.