英文:
How to store DateTime with exact decimals in SQL Server using Java
问题
我正在尝试从Informix获取Datetime,并通过Java将其存储在SQL Server中,使用Java中的java.util.Date
数据类型和SQL Server中的datetime2
数据类型,但我发现SQL数据和Informix数据之间存在小数差异,这给我造成了比较问题。
有人能建议我如何解决这个小数不匹配问题吗?
英文:
I am trying to get Datetime from Informix and stored it in SQL Server through Java by using java.util.Date
datatype in Java and datetime2
datatype in SQL Server but I am getting decimals difference between SQL data and Informix data and this creates a comparison problem for me.
Can anyone suggest me to fix this decimal mismatch?
专注分享java语言的经验与见解,让所有开发者获益!
评论