View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001515 | Database Workbench v5 | General | public | 2017-09-08 10:04 | 2017-10-27 12:38 |
Reporter | Arno Brinkman | Assigned To | Martijn Tonies | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 5.2.2 | ||||
Fixed in Version | 5.3.4 | ||||
Summary | 0001515: Export data to SQL fails on datetime fields in SQL Server | ||||
Description | ScanDatumTijd is a datetime field in MSSQL but is not export correctly '2017-08-2908:4308:43:10.000' The first 08:43 needs to be a space here INSERT INTO Scans (ScanID, ScanTypeID, ScanDatumTijd, ScannerID, MedewerkerNummer, StapelwagenID, AutoID, FlowerTrack, DebiteurExport, SlotplaatID, ScanLocatieEAN, TMSExport, Deelkar, OpdrachtGeverEAN, BestemmingEAN, HerkomstEAN, EenheidTypeID, DocumentID, Afgedrukt, OpdrachtgeverInKennisGesteld, DistributiebonID, AanvoerbriefID) VALUES (19581531, 25, '2017-08-2908:4308:43:10.000', 1020097439, 899, '80030871302200763700024983', NULL, 'T', 'T', NULL, '8713783880203', 'T', 0, '8714231180074', NULL, NULL, 1, '08000000252151', 'T', 'F', NULL, NULL); | ||||
Tags | No tags attached. | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2017-09-08 10:04 | Arno Brinkman | New Issue | |
2017-09-12 13:06 | Martijn Tonies | Assigned To | => Martijn Tonies |
2017-09-12 13:06 | Martijn Tonies | Status | new => assigned |
2017-09-12 13:06 | Martijn Tonies | Summary | Export Result to clipboard as INSERT from datagrid, goes wrong with datetime fields (at least MSSQL) => Export data to SQL fails on datetime fields in SQL Server |
2017-09-12 13:06 | Martijn Tonies | Status | assigned => resolved |
2017-09-12 13:06 | Martijn Tonies | Fixed in Version | => 5.3.4 |
2017-09-12 13:06 | Martijn Tonies | Resolution | open => fixed |
2017-10-27 12:38 | Martijn Tonies | Status | resolved => closed |