sql - 我如何计算 MSSQL 中解决时间的 2 个日期计数
问题描述
SELECT* from ticketOperations
--this is operations table
INNER JOIN tickets ON tickets.ID = ticketOperations.ticketID,
--they connect with foreign key
DATEDIFF(DAY,tickets.date, ticketOperations.closingDate) AS SOLUTIONTIME
--this is calculatefunction
WHERE tickets.ticketType=0
--tickettype
解决方案
当您在没有任何表达式或条件的情况下使用DATEDIFF
in子句时,您将面临问题。ON
消息 208,级别 16,状态 1,第 6 行无效的对象名称“DATEDIFF”。这是我的错误字符串
如果您想知道日期的差异,请在SELECT
子句中使用它。
SELECT tickets.*, ticketOperations.*,
DATEDIFF(DAY,tickets.date, ticketOperations.closingDate) AS SOLUTIONTIME
from ticketOperations
INNER JOIN tickets ON tickets.ID = ticketOperations.ticketID,
WHERE tickets.ticketType=0
推荐阅读
- date - Google表格脚本:从范围内的变量中查找日期
- unity3d - 统一如何制作游戏菜单?
- python - 电子邮件地址的 WtForms 验证器
- python - 如何在Python中将字节作为非阻塞传递给Popen
- java - android开发出错,gradle build失败
- android - canned_fs_config vs fs_config in Android ext4 utils
- javascript - How do I avoid lazyloading placeholders (LQIP) from being cached in Google Images
- amazon-web-services - ternary conditional operators in terraform
- angular - 在 StackBlitz 中出现“this._ngZone is undefined”错误
- r - 通过在 R 中对词云的变量进行分组如何分开?