topic How to get the differnce betweent two timestamp in DQL

How to get the differnce betweent two timestamp

marusla — Tue, 25 Nov 2025 10:33:37 GMT

Hello i have this code

| fieldsAdd FechaTs = toTimestamp(Fecha)
| summarize
FechaInicial = min(FechaTs),
FechaFinal = max(FechaTs),
by: { Identificador }
| fieldsAdd
DiffMs = toLong(FechaFinal - FechaInicial),
DiffSec = toLong((FechaFinal - FechaInicial) / 1000)
| sort DiffMs desc

Re: How to get the differnce betweent two timestamp

JeanBlanc — Mon, 24 Nov 2025 21:37:03 GMT

Hi @marusla 🙂

You can calculate the difference directly during the pipeline by adding a new field that performs the subtraction between the two values you already computed.

For example, after defining DiffMs and DiffSec, simply add:

| fieldsAdd Difference = DiffMs - DiffSec

So your full query would look like:

| fieldsAdd FechaTs = toTimestamp(Fecha) | summarize FechaInicial = min(FechaTs), FechaFinal = max(FechaTs), by: { Identificador } | fieldsAdd DiffMs = toLong(FechaFinal - FechaInicial), DiffSec = toLong((FechaFinal - FechaInicial) / 1000) | fieldsAdd Difference = DiffMs - DiffSec | sort DiffMs desc

This adds a new column with the subtraction result without modifying the rest of your logic.

Best regards,

Re: How to get the differnce betweent two timestamp

marusla — Mon, 24 Nov 2025 21:45:48 GMT

i use the commands, but stil have the problem

Re: How to get the differnce betweent two timestamp

marusla — Tue, 25 Nov 2025 01:42:33 GMT

Thanks, i have i have to use other convertion

| summarize FechaInicial = min(Fecha), FechaFinal = max(Fecha), by: { Identificador}
| fieldsAdd Duracion = (totimestamp(FechaFinal) - totimestamp(FechaInicial))