看起来在早期的运行时中（至少在13.2中测试过）datediff支持秒单位。
https://docs.databricks.com/en/sql/language-manual/functions/datediff3.html
这只是生成一些随机id，其中包含多个值和模糊时间以显示语法。
还显示了与原始姿势相同的间隔提取物。

%sql
with some_ids_and_random_ints as (
  select
    id,
    floor(rand(5) * 1000) random_int
  from
    range(1000) AS t
),
force_dups_on_id as (
  select
    mod(id, 10) as id_with_dups,
    timestampadd(second, random_int, current_timestamp()) as some_time
  from
    some_ids_and_random_ints
),
result_compare as (
select
  *,
  datediff(
    second,
    lag(some_time) over (
      partition by id_with_dups
      order by
        some_time
    ),
    some_time
  ) as diff_inbuilt_function,
  (some_time - (LAG(some_time, 1) OVER (partition by id_with_dups order by some_time))) tdiff_as_interval
from
  force_dups_on_id
order by
  id_with_dups,
  some_time
)
select id_with_dups,
       some_time,
       diff_inbuilt_function,
       cast(extract(second from tdiff_as_interval) as integer) as seconds_from_interval
  from result_compare

字符串