显示其余的日子

Question

我有一个asp.net系统在数据库中有一个带有日期时间值的PODate字段。如何减去交货到货前剩下的日子。我想在列表视图中以列显示

示例：交货日期为10月21日。它必须在交货到达之前显示14天。

它可以在选择查询中完成，或者它必须在我的visual studio中完成。

Answer 1

如果您正在使用SQL Server那么你可以使用此查询：

SELECT DATEDIFF(day,Column1,Column2) AS DiffDate from TableName 

或者，如果你想这样做的c#那么你可以使用TimeSpan对象

DateTime date1; 
DateTime date2; 
return (date1 - date2).TotalDays; 

如果您子查询只返回一个值，然后您可以尝试

SELECT ABS((SELECT DATEDIFF(day,Column1,Column2) AS DiffDate from TableName)) 

Answer 2

你可以用C＃

DateTime date1; 
DateTime date2; 
return (date1 - date2).Days; 

Answer 3

做到这可以帮助你找到的差异。

SELECT DATEDIFF(DAY, GETDATE(), deliveryDate) AS DayDiff 
SELECT DATEDIFF(MINUTE, GETDATE(), deliveryDate) AS MinuteDiff 
SELECT DATEDIFF(SECOND, GETDATE(), deliveryDate) AS SecondDiff 
SELECT DATEDIFF(WEEK, GETDATE(), deliveryDate) AS WeekDiff 
SELECT DATEDIFF(HOUR, GETDATE(), deliveryDate) AS HourDiff 

Answer 4

它可以同时在做，

我宁愿它在Visual Studio中进行，因为这是明显地呈现 逻辑。

C＃

DateTime oldDate = new DateTime(2002,7,15); 
DateTime newDate = DateTime.Now; 

// Difference in days, hours, and minutes. 
TimeSpan ts = newDate - oldDate; 
// Difference in days. 
int differenceInDays = ts.Days; 

Console.WriteLine("Difference in days: {0} ", differenceInDays); 

https://msdn.microsoft.com/en-us/library/aa287590%28v=vs.71%29.aspx?f=255&MSPPError=-2147217396

VB

Dim firstDate, msg As String 
Dim secondDate As Date 
firstDate = InputBox("Enter a date") 
Try 
    secondDate = CDate(firstDate) 
    msg = "Days from today: " & DateDiff(DateInterval.Day, Now, secondDate) 
    MsgBox(msg) 
Catch 
    MsgBox("Not a valid date value.") 
End Try 

https://msdn.microsoft.com/en-us/library/b5xbyt6f(v=vs.90).aspx