I have a problem with the returned date from my database. I use an hp-nonstop SQL/mp database. My problem is that the time after the seconds isn't formatted correctly. However it is not that the date gets truncated after the milliseconds, there is litteraly three zeros that appears out of nowhere.
For example
Expected date
2017-08-08 11:11:11.123456
Received date
2017-08-08 11:11:11.000123
I do not think my problem come from my request since even by doing a simple
select * from table where something="something"
I still have an error.
I use the 2.10 version of non-stop SQL by H-P, if it can help.
Someone already had the same problem as me http://knowledgebase.progress.com/articles/Article/2747 , but he was using another DLL.
Is it a known bug from non stop SQL and ODBC ? that can be solved by updating the dll ? I found nothing on the H-P website.