user1937012
Reputation: 385
Delphi SQL DateTime2(5) Fraction Truncated
Got one Table with DateTime2(5) field . It looks like this :
2021-09-07 10:54:14.97317
Now I setup FDConnection with one FDQuery . I get the Column back as TSQLTimeStamp. Now I try this :
Label2.Caption:=FDQuery1lastmodzeit.Value.Fractions.ToString;
and I only get 973 back .
Using SQL 2012 , and it's SQL SERVER NATIVE CLIENT 11.0 .
Upvotes: 0
Views: 132
Answers (0)
Related Questions
- How to truncate seconds in TSQL?
- how can i store datetime in the table without time fraction part?
- Truncate Datetime to Second (Remove Milliseconds) in T-SQL
- Is there a way to add fractions in dateadd
- MS SQL datetime precision problem
- T-SQL to trim a datetime to the nearest date?
- The fractional part of the provided time value overflows exception SQL Server 2017
- Truncating date + time using DateTime2
- Why does "WHERE (Time_Stamp >= TDateTime-variable)" ignore fractional seconds?
- SQL Server date format handling