Find time Discrepancy

[Sinchan Nikam]

Hi Freinds, Please help me i m using vb 6.0 and sql server 2000. i have one table with 2 fields name as "start time" & "end time" i want check in discrepancy of time when insert a data . i use flex grid for data entry.

[Dave Kreskowiak]

For anyone to help you, you're going to have to define what you mean by "check in descrepancy of time".

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008

[Lost User]

Subtract the two fields.

[sph3rex]

http://msdn.microsoft.com/en-us/library/aa258269(SQL.80).aspx[^] or google for DateDiff function.