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