An asp.net date issue ??

mistroy

Excuse me, I want to subtract the values ​​of two date fields in the database, and then display the result of the subtraction in the DataGrid in seconds? ?
What should I do? ? ?

shenmue024

select DateDiff (ss, d1, d2) from table.

shenmue024

Note that these two times should not be too long apart, too long will cause the derivative integer to overflow.

royhau

Fast back