SELECT Num FROM [UseCard]where [BeginTime]=[EndTime] 这样就没问题
CREATE TABLE #TP ( ID INT IDENTITY, BEGINTIME SMALLDATETIME, ENDTIME SMALLDATETIME )INSERT INTO #TP SELECT '2010-12-10 16:20:30','2010-12-10 17:21:30'INSERT INTO #TP SELECT '2010-12-10 16:20:30','2010-12-10 16:20:30'----方法一: SELECT * FROM #TP t WHERE T.BEGINTIME=T.ENDTIME----方法二: SELECT * FROM #TP t WHERE DATEDIFF(ss,T.BEGINTIME,T.ENDTIME)=0
这样就没问题
(
ID INT IDENTITY,
BEGINTIME SMALLDATETIME,
ENDTIME SMALLDATETIME
)INSERT INTO #TP SELECT '2010-12-10 16:20:30','2010-12-10 17:21:30'INSERT INTO #TP SELECT '2010-12-10 16:20:30','2010-12-10 16:20:30'----方法一:
SELECT * FROM #TP t
WHERE T.BEGINTIME=T.ENDTIME----方法二:
SELECT * FROM #TP t
WHERE DATEDIFF(ss,T.BEGINTIME,T.ENDTIME)=0