datetime format incorrect
yucikala opened this issue · 0 comments
I have an issue with datetime format. I have the same databases (develop and production). Develop is local and prod is on hosting. I dont know why, but i can not dump production db.
Reason is, that i have
2023-02-01 17:04:22.1617|ERROR|MysqlBackup.Program|System.FormatException: Input string was not in a correct format.
at System.DateTimeFormat.FormatCustomized(DateTime dateTime, ReadOnlySpan1 format, DateTimeFormatInfo dtfi, TimeSpan offset, StringBuilder result) at System.DateTimeFormat.FormatStringBuilder(DateTime dateTime, ReadOnlySpan
1 format, DateTimeFormatInfo dtfi, TimeSpan offset)
at System.DateTimeFormat.Format(DateTime dateTime, String format, IFormatProvider provider, TimeSpan offset)
at MySQLBackupNetCore.Methods.QueryExpress.ConvertToSqlFormat(Object ob, Boolean wrapStringWithSingleQuote, Boolean escapeStringSequence, MySqlColumn col, BlobDataExportMode blobExportMode)
at MySQLBackupNetCore.MySqlBackup.Export_GetValueString(MySqlDataReader rdr, MySqlTable table)
at MySQLBackupNetCore.MySqlBackup.Export_RowsData_Insert_Ignore_Replace(String tableName, String selectSQL)
at MySQLBackupNetCore.MySqlBackup.Export_RowsData(String tableName, String selectSQL)
at MySQLBackupNetCore.MySqlBackup.Export_Rows(String tableName, String selectSQL)
at MySQLBackupNetCore.MySqlBackup.Export_TableRows()
at MySQLBackupNetCore.MySqlBackup.ExportStart()
at MySQLBackupNetCore.MySqlBackup.ExportToFile(String filePath)
at MysqlBackup.Program.Test() in D:\Projekty\smallprograms\MysqlBackup\Program.cs:line 396
I think, that there is default format (at mysql) like 1.12.2023 00:15:26. I dont know hot to change it or fix.... I can not find differences between develop and prod.
I find, that datetime column is ok. Problem is with timestamp