Poco::Data::PostgreSQL - DateTime extraction truncates fractional seconds #3559
Description
The culprit is the call to DateTimeParser::tryParse() without a format string in Extractor.cpp, line 317.
Needs to be changed to include a format string that includes fractional seconds:
bool Extractor::extract(std::size_t pos, DateTime& val)
{
OutputParameter outputParameter = extractPreamble(pos);
if (isColumnNull(outputParameter))
{
return false;
}
int tzd = -1;
DateTime dateTime;
if (!DateTimeParser::tryParse("%Y-%m-%d %H:%M:%s", outputParameter.pData(), dateTime, tzd))
{
return false;
}
dateTime.makeUTC(tzd);
val = dateTime;
return true;
}