We’re working on a product where timing is quite important. We therefor would like to store a Datetime stamp up to a thousands of a second. I’ve tried multiple solutions manipulating the IO-format of the domain I’m storing the datetimestamp in unfortunately without any luck. The IO formats I tried so far are:
- YYYY-MM-DD HH24:MI:SS.FF3
- YYYY-MM-DD HH24:MI:SS.NNN
- YYYY-MM-DD HH24:MI:SS.SSS
they each store the datetime stamps without the milliseconds.
Even when manually inserting the date via a query in USoft Application, it inserts it without the milliseconds, also shown below
|
|
Running that exact query directly on the database, and the milliseconds get inserted
|
|
Is there an easy way to work with milliseconds?
Best answer by USoft Support
View original