I hope this is the right forum for this. I tried exporting data from a table using this procedure:
- SQL Server Management Studio -> Right-click on database -> Tasks -> Export Data...
- Source: SQL Server, Destination: Flat File destination (delimited).
The data was correctly exported, but when I try to parse the file using FileHelpers, DateTime.ParseExact() fails for any date with non-integer seconds: I discovered the decimal part of the number of seconds has 9 digits, while DateTime.ParseExact() accepts
only up to 7 digits, even with a custom format.
//The output date has the following format, and I can't:
// either find a format that accepts it,
// or prevent SQL server from outputting all those digits.
"yyyy-MM-dd HH:mm:ss.FFFFFFFFF", //This doesn't work
//A FormatException is thrown.
View Complete Post