SQL Server上具有时间数据类型的比较运算符 [英] Comparison Operators with Time data type at SQL server

问题描述

大家好

我想问问我是否可以在SQL Server 2008上将比较运算符(>，<，=，< =，> =)与Time数据类型一起使用?
如果有人可以给出一些解释或例子，那将是一件很棒的事情


在此先感谢:)

Hello all

I want to ask if I can use Comparison Operators (>, <, =, <=, >=) with Time data type at SQL Server 2008 ?

if someone can give some explanation or example it will be great thing


thanks in advance : )

推荐答案

绝对可以.

http://dataeducation.com/blog/datetime-calculations-part-1 [ ^ ]
http://dataeducation.com/blog/datetime-calculations-part-2 [ ^ ]

Absolutely you can.

http://dataeducation.com/blog/datetime-calculations-part-1[^]
http://dataeducation.com/blog/datetime-calculations-part-2[^]

这篇关于SQL Server上具有时间数据类型的比较运算符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！