blocks|key|1034658|text|您可以使用DATEPART获取：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1034659|++`second,+++++minute,+++++hour,+++++day,+++++week,+++++month,+++++year`++|code-block|syntax|javascript|1034660|更多参考资料。|offset|length|1034661|使用where条件获得所需的范围。|style|CODE|1034662|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms174420%2528loband%2529.aspx^0|0|0|0|6|0|0|2|5|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@$I|Z|J|10|1|11]]|A|$]]|$1|K|3|L|5|6|7|12|8|@$I|13|J|14|M|N]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

You can use &lt;code>DATEPART&lt;/code> to get:

<code> 
 second,
 minute,
 hour,
 day,
 week,
 month,
 year 
</code>

<a href="http://msdn.microsoft.com/en-us/library/ms174420%28loband%29.aspx" rel="nofollow">Reference for more</a>.

Use the <code>where</code> condition to get the desired range.

blocks|key|1603353|text|我很难弄清楚你到底想要什么。以下是基于你迄今为止的评论的一些例子：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1603354|10-11，或1-5|offset|length|style|BOLD|1603355|SELECT+*+from+table+WHERE+Timestamp+>=+'20121011+10:00'
++++++++++++++++++++++and+Timestamp+<++'20121011+11:00'
SELECT+*+from+table+WHERE+Timestamp+>=+'20121011+01:00'
++++++++++++++++++++++and+Timestamp+<++'20121011+05:00'|code-block|syntax|javascript|1603356|或者如果你需要“今天”自动改变，那么|1603357|SELECT+*+from+table+WHERE+Timestamp+>=+DateAdd(Hour,10,CAST(GetDate()+as+Date))
++++++++++++++++++++++and+Timestamp+<++DateAdd(Hour,11,CAST(GetDate()+as+Date))|1603358|昨天下午1:30-今天凌晨3点|1603359|SELECT+*+from+table+WHERE+Timestamp+>=+'20121010+13:30'
++++++++++++++++++++++and+Timestamp+<++'20121011+03:00'|1603360|，是的，一天一小时，|1603361|现在，如果您要使用DATEPART来解决这个问题，那么让我们假设10-11|1603362|SELECT+*+from+table+WHERE+DATEPART(hour,Timestamp)+=+10|1603363|这将在几天内运行，而不是萨格勒，也就是说，不能在真正不需要的索引上搜索它。|1603364|​|1603365|这些是从哪来的？|1603366|1603367|第二量程|unordered-list-item|1603368|分钟范围|1603369|小时范围|1603370|日范围|1603371|周范围|1603372|月份范围|1603373|年份范围|1603374|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Sargable^0|0|0|A|0|0|0|0|0|F|0|0|0|A|0|0|0|C|3|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1V|8|@$D|1W|E|1X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1Y|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|20|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|21|8|@$D|22|E|23|F|G]]|9|@]|A|$]]|$1|S|3|T|5|J|7|24|8|@]|9|@]|A|$K|L]]|$1|U|3|V|5|6|7|25|8|@$D|26|E|27|F|G]]|9|@]|A|$]]|$1|W|3|X|5|6|7|28|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|J|7|29|8|@]|9|@]|A|$K|L]]|$1|10|3|11|5|6|7|2A|8|@]|9|@$D|2B|E|2C|1|2D]]|A|$]]|$1|12|3|13|5|6|7|2E|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|2F|8|@]|9|@]|A|$]]|$1|16|3|13|5|6|7|2G|8|@]|9|@]|A|$]]|$1|17|3|18|5|19|7|2H|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|19|7|2I|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|19|7|2J|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|19|7|2K|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|19|7|2L|8|@]|9|@]|A|$]]|$1|1I|3|1J|5|19|7|2M|8|@]|9|@]|A|$]]|$1|1K|3|1L|5|19|7|2N|8|@]|9|@]|A|$]]|$1|1M|3|-4|5|6|7|2O|8|@]|9|@]|A|$]]]|1N|$1O|$5|1P|1Q|1R|A|$1S|1T]]]]

I'm having a hard time figuring out what you really want. Here are some examples based on your comments so far:

10-11, or 1-5

<pre><code>SELECT * from table WHERE Timestamp &gt;= '20121011 10:00'
 and Timestamp &lt; '20121011 11:00'
SELECT * from table WHERE Timestamp &gt;= '20121011 01:00'
 and Timestamp &lt; '20121011 05:00'
</code></pre>

Or if you need "today" to automatically change, then

<pre><code>SELECT * from table WHERE Timestamp &gt;= DateAdd(Hour,10,CAST(GetDate() as Date))
 and Timestamp &lt; DateAdd(Hour,11,CAST(GetDate() as Date))
</code></pre>

1:30pm yesterday - 3am today

<pre><code>SELECT * from table WHERE Timestamp &gt;= '20121010 13:30'
 and Timestamp &lt; '20121011 03:00'
</code></pre>

yes an hour in a single day 
Now, if you were to use DATEPART to solve this, let's say for 10-11

<pre><code>SELECT * from table WHERE DATEPART(hour,Timestamp) = 10
</code></pre>

That would run across days and would not be <a href="http://en.wikipedia.org/wiki/Sargable" rel="nofollow">SARGABLE</a>, i.e. it cannot be searched on an index which is really not what you want.

<hr>
Where do these come in?

<ul>
<li>second range</li>
<li>minute range</li>
<li>hour range</li>
<li>day range</li>
<li>week range</li>
<li>month range</li>
<li>year range</li>
</ul>

I'm new to SQL and the time functions are different than mySQL so I'm having a terrible time finding a good site reference with USEFUL timestamp queries. 

I'm not able to locate the correct way of doing this query in SQL:

<pre><code>Id Timestamp
-----------------------------------
1145744 2012-10-10 18:15:11.500
1145743 2012-10-10 18:15:11.313
1145742 2012-10-10 18:15:11.313
1145741 2012-10-10 18:15:11.253
1145740 2012-10-10 18:15:11.190
1145739 2012-10-10 18:15:11.190
1145738 2012-10-10 18:15:11.127
1145737 2012-10-10 18:15:11.067
1145736 2012-10-10 18:15:11.063
1145735 2012-10-10 18:15:10.940
1145734 2012-10-10 18:15:10.817


SELECT * from table WHERE Timestamp ... RANGE
</code></pre>

I need the range of 2 timestamps so I can select rows by the following parameters:

<ol>
<li>second range</li>
<li>minute range</li>
<li>hour range</li>
<li>day range</li>
<li>week range</li>
<li>month range</li>
<li>year range </li>
</ol>

Is there one function to put in 2 timestamps and get the range? or is this a mix of functions I need? 

Any good site references would be greatly appriceated. MSDN site isn't helping me isolate the proper way of doing this. I've been searching for about an hour trying to get the last day from 1:30PM to 1:30PM today.

What's the SQL function for timestamp manipulation?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我对SQL很陌生，时间函数与mySQL不同，所以我很难找到一个有有用时间戳查询的好站点引用。我无法在SQL中找到执行此查询的正确方法：Id          Timestamp-----------------------------------1145744 2012-10-10 18:15:11.500114574...

问用于时间戳操作的SQL函数是什么？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用于时间戳操作的SQL函数是什么？EN