Hi
we have a SQL DB containing two fields, both defined as datetime2
fieldA 2020-10-20 07:25:58.4543440
fieldB 2020-10-20 07:25:58.4658980
We need to know the difference in milliseconds between fieldA and fieldB.
This doesn't work:
millisecond(fieldB , 'yyyy-MM-dd HH:mm:ss.SSSSSSS') - millisecond(fieldA, 'yyyy-MM-dd HH:mm:ss.SSSSSSS')
I get some strange error in the expression builder:
{"value":"11","type":"LosslessNumber","isLosslessNumber":true}
Anybody knows what I am doing wrong??
Tried other options, but don't get it working.
By the way, an additional requirement: If one of the fields contains a NULL value, the outcome must be 0.
regards
Ron



