数据库里有2个字段Date1,Date2,类型分别为varchar 、datatime现在需要把同一条记录的Date1与Date2进行比较大小,得出相隔的天数,于是我写了这个函数:
Public Function GetDateNum(ByVal inDate1, ByVal inDate2) As Integer
Dim indate11 As DateTime = inDate1
Dim indate22 As DateTime = inDate2
Return DateDiff(DateInterval.Day, indate11, inDate22)
End Function
好象得出的结果好象有点偏差啊?但是怎么写?请各位指点
Public Function GetDateNum(ByVal inDate1, ByVal inDate2) As Integer
Dim indate11 As DateTime = inDate1
Dim indate22 As DateTime = inDate2
Return DateDiff(DateInterval.Day, indate11, inDate22)
End Function
好象得出的结果好象有点偏差啊?但是怎么写?请各位指点
DATEDIFF(day, UploadDate, Convert(datetime,ArivalDate)) AS DayNum