in VB.NET i want to create a sql statement for sql-server that gives me the duration.
FromDateTime= 07/04/2006 15:00
ToDateTime= 07/04/2006 15:10
FromDateTime= 07/04/2006 15:20
ToDateTime= 07/04/2006 15:25
FromDateTime= 07/04/2006 15:30
ToDateTime= 07/04/2006 15:50
When i do this "SELECT <what to place here?> FROM Table WHERE Filterfield=1"
i should get something like
30minutes or even in seconds or milliseconds, i don't care about that, i just want this data out like that.
seconds, milliseconds,minutes,... are easy to convert to anything else.