Unable to convert MySQL date/time to System.DateTime, set AllowZeroDateTime=True or ConvertZeroDateTime=True in the connection string. · Issue #1763 · PomeloFoundation/Pomelo.EntityFrameworkCore.MySql · GitHub
![Convert date format to format that will be used for MySQL insertion - Studio - UiPath Community Forum Convert date format to format that will be used for MySQL insertion - Studio - UiPath Community Forum](https://global.discourse-cdn.com/uipath/original/4X/e/4/3/e4342d023b79f376687bbf668de999569846a926.png)
Convert date format to format that will be used for MySQL insertion - Studio - UiPath Community Forum
![SQL SERVER – Multiple ways to remove Milliseconds from Datetime (Truncate Datetime till Second) | SQL Server Portal SQL SERVER – Multiple ways to remove Milliseconds from Datetime (Truncate Datetime till Second) | SQL Server Portal](https://raresql.files.wordpress.com/2013/05/truncatemilliseconds.jpg)