Required DateTime Precision #679
morteza-jabarzare
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Since DateTime precision is required based on business requirements, programmers sometimes need to store DateTime values with different precisions.
In line number 70 of QueryBuilder/SqlResult.cs, the code "<< return "'" + date.ToString("yyyy-MM-dd HH:mm:ss") + "'"; >>" causes all datetimes to be stored with second precision, which may cause issues for certain business scenarios.
I recommend using "<< return "'" + date.ToString("yyyy-MM-dd HH:mm:ss.FFFFFFF") + "'"; >>" instead, which delegates the DateTime precision serialization to the input value that can be changed by the end developer during Insert and Update commands.
I made these changes for myself, and my problems were easily resolved.
Perhaps this discussion will improve this project.
Beta Was this translation helpful? Give feedback.
All reactions