从 t-sql select 中的日期比较获取布尔值
我想知道在 ms-sql (2005) 中是否可以执行以下操作,
SELECT (expiry < getdate()) AS Expired
FROM MyTable
WHERE (ID = 1)
我基本上想将日期与布尔值进行比较,这在语句的选择部分中是否可能?
I am wondering if something along the lines of the following is possible in ms-sql (2005)
SELECT (expiry < getdate()) AS Expired
FROM MyTable
WHERE (ID = 1)
I basically want to evaluate the date compare to a boolean, is that possible in the select part of the statement?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
不直接。您必须使用 CASE,CAST 意味着它被客户端代码解释为布尔值
另一种解决方案,其中需要一行或零行:
Not directly. You have to use CASE, the CAST means it's interpreted as boolean by client code
Another solution where one or zero rows are expected:
我正在寻找一个布尔值。
这就是我的解决方案
I was looking for a boolean.
So this was my solution