partiql-lang-kotlin icon indicating copy to clipboard operation
partiql-lang-kotlin copied to clipboard

Published 20 hours ago • verified publisher icon partiql

Add millisecond option for date_diff

Open therapon opened this issue 5 years ago • 2 comments

It would be nice to have the option to use date_diff that outputs the time difference in milliseconds. Ex: DATE_DIFF(milliseconds, my_timestamp_field, UTCNOW())

therapon avatar Feb 13 '20 21:02 therapon

Is this SQL-92?

dlurton avatar Dec 17 '21 18:12 dlurton

Is this SQL-92?

I do not think so. I believe SQL92 has intervals and relies on extract to grab scalars from an interval. date_diff seems to be a common date related function across DB implementations.

I do not recall the source for adding this issue though (ask from someone or "coverage" for date_diff not sure)

therapon avatar Dec 18 '21 07:12 therapon