blocks|key|1384742|text|SELECT+*+
FROM+table_name
WHERE+table_name.the_date+>+DATE_SUB(CURDATE(),+INTERVAL+1+DAY)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1384743|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT * 
FROM table_name
WHERE table_name.the_date &gt; DATE_SUB(CURDATE(), INTERVAL 1 DAY)
</code></pre>

blocks|key|1384645|text|在MySQL中|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1384646|SELECT++*
FROM++++mytable
WHERE+++record_date+>=+NOW()+-+INTERVAL+1+DAY|code-block|syntax|javascript|1384647|在SQL+Server中|1384648|SELECT++*
FROM++++mytable
WHERE+++record_date+>=+DATEADD(day,+-1,+GETDATE())|1384649|在Oracle中|1384650|SELECT++*
FROM++++mytable
WHERE+++record_date+>=+SYSDATE+-+1|1384651|在PostgreSQL中|1384652|SELECT++*
FROM++++mytable
WHERE+++record_date+>=+NOW()+-+'1+day'::INTERVAL|1384653|在Redshift中|1384654|SELECT++*
FROM++++mytable
WHERE+++record_date+>=+GETDATE()+-+'1+day'::INTERVAL|1384655|在SQLite中|1384656|SELECT++*
FROM++++mytable
WHERE+++record_date+>=+datetime('now','-1+day')|1384657|在MS+Access中|1384658|SELECT++*
FROM++++mytable
WHERE+++record_date+>=+(Now+-+1)|1384659|entityMap^0|1|5|0|0|1|A|0|0|1|6|0|0|1|A|0|0|1|8|0|0|1|6|0|0|1|9|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|1D|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|1E|8|@$9|1F|A|1G|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|1H|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|1I|8|@$9|1J|A|1K|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|H|7|1L|8|@]|D|@]|E|$I|J]]|$1|S|3|T|5|6|7|1M|8|@$9|1N|A|1O|B|C]]|D|@]|E|$]]|$1|U|3|V|5|H|7|1P|8|@]|D|@]|E|$I|J]]|$1|W|3|X|5|6|7|1Q|8|@$9|1R|A|1S|B|C]]|D|@]|E|$]]|$1|Y|3|Z|5|H|7|1T|8|@]|D|@]|E|$I|J]]|$1|10|3|11|5|6|7|1U|8|@$9|1V|A|1W|B|C]]|D|@]|E|$]]|$1|12|3|13|5|H|7|1X|8|@]|D|@]|E|$I|J]]|$1|14|3|15|5|6|7|1Y|8|@$9|1Z|A|20|B|C]]|D|@]|E|$]]|$1|16|3|17|5|H|7|21|8|@]|D|@]|E|$I|J]]|$1|18|3|-4|5|6|7|22|8|@]|D|@]|E|$]]]|19|$]]

In <code>MySQL</code>:

<pre><code>SELECT *
FROM mytable
WHERE record_date &gt;= NOW() - INTERVAL 1 DAY
</code></pre>

In <code>SQL Server</code>:

<pre><code>SELECT *
FROM mytable
WHERE record_date &gt;= DATEADD(day, -1, GETDATE())
</code></pre>

In <code>Oracle</code>:

<pre><code>SELECT *
FROM mytable
WHERE record_date &gt;= SYSDATE - 1
</code></pre>

In <code>PostgreSQL</code>:

<pre><code>SELECT *
FROM mytable
WHERE record_date &gt;= NOW() - '1 day'::INTERVAL
</code></pre>

In <code>Redshift</code>:

<pre><code>SELECT *
FROM mytable
WHERE record_date &gt;= GETDATE() - '1 day'::INTERVAL
</code></pre>

In <code>SQLite</code>:

<pre><code>SELECT *
FROM mytable
WHERE record_date &gt;= datetime('now','-1 day')
</code></pre>

In <code>MS Access</code>:

<pre><code>SELECT *
FROM mytable
WHERE record_date &gt;= (Now - 1)
</code></pre>

blocks|key|1384851|text|MySQL：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1384852|SELECT+*+
FROM+table_name
WHERE+table_name.the_date+>+DATE_SUB(NOW(),+INTERVAL+24+HOUR)|code-block|syntax|javascript|1384853|时间间隔可以是年、月、日、小时、分钟、秒|1384854|例如，在过去的10分钟内|1384855|SELECT+*+
FROM+table_name
WHERE+table_name.the_date+>+DATE_SUB(NOW(),+INTERVAL+10+MINUTE)|1384856|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

MySQL :

<pre><code>SELECT * 
FROM table_name
WHERE table_name.the_date &gt; DATE_SUB(NOW(), INTERVAL 24 HOUR)
</code></pre>

The INTERVAL can be in YEAR, MONTH, DAY, HOUR, MINUTE, SECOND

For example, In the last 10 minutes

<pre><code>SELECT * 
FROM table_name
WHERE table_name.the_date &gt; DATE_SUB(NOW(), INTERVAL 10 MINUTE)
</code></pre>

blocks|key|1384724|text|未指定哪个SQL，SQL+2005+/+2008|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1384725|SELECT+yourfields+from+yourTable+WHERE+yourfieldWithDate+>+dateadd(dd,-1,getdate())|code-block|syntax|javascript|1384726|如果您使用的是2008年精度增加的日期类型，则使用新的sysdatetime()函数，同样，如果在内部使用UTC时间交换UTC调用。|1384727|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Which SQL was not specified, SQL 2005 / 2008

<pre><code>SELECT yourfields from yourTable WHERE yourfieldWithDate &gt; dateadd(dd,-1,getdate())
</code></pre>

If you are on the 2008 increased accuracy date types, then use the new sysdatetime() function instead, equally if using UTC times internally swap to the UTC calls.

blocks|key|1169786|text|如果考虑的时间戳是UNIX时间戳，则需要首先将UNIX时间戳(例如1462567865)转换为mysql时间戳或数据|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1169787|SELECT+*+FROM+`orders`+WHERE+FROM_UNIXTIME(order_ts)+>+DATE_SUB(CURDATE(),+INTERVAL+1+DAY)|code-block|syntax|javascript|1169788|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If the timestamp considered is a UNIX timestamp
You need to first convert UNIX timestamp (e.g 1462567865) to mysql timestamp or data 

<pre><code>SELECT * FROM `orders` WHERE FROM_UNIXTIME(order_ts) &gt; DATE_SUB(CURDATE(), INTERVAL 1 DAY)
</code></pre>

blocks|key|1169550|text|select+...
from+...
where+YourDateColumn+>=+getdate()-1|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1169551|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>select ...
from ...
where YourDateColumn &gt;= getdate()-1
</code></pre>

blocks|key|1384949|text|您好，我现在它已经过去了很多时间，从最初的帖子，但我得到了类似的问题，我想分享。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1384950|我得到了一个格式为YYYY-MM-DD+hh:mm:ss的日期时间字段，我想访问一整天，所以这是我的解决方案。|1384951|MySQL中的函数DATE()：提取日期或日期时间表达式的日期部分。|1384952|SELECT+*+FROM+`your_table`+WHERE+DATE(`your_datatime_field`)='2017-10-09'|code-block|syntax|javascript|1384953|有了这个，我得到了这一天的所有行寄存器。|1384954|我希望这对任何人都有帮助。|1384955|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|T|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Hello i now it past a lot of time from the original post but i got a similar problem and i want to share.

I got a datetime field with this format YYYY-MM-DD hh:mm:ss, and i want to access a whole day, so here is my solution.

The function DATE(), in MySQL: Extract the date part of a date or datetime expression.

<pre><code>SELECT * FROM `your_table` WHERE DATE(`your_datatime_field`)='2017-10-09'
</code></pre>

with this i get all the row register in this day.

I hope its help anyone.

blocks|key|1169583|text|SELECT+*+
FROM+tableName+
WHERE+datecolumn+>=+dateadd(hour,-24,getdate())|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1169584|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT * 
FROM tableName 
WHERE datecolumn &gt;= dateadd(hour,-24,getdate())
</code></pre>

blocks|key|1384784|text|在SQL+Server中(过去24小时)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1384785|SELECT++*
FROM++++mytable
WHERE+++order_date+>+DateAdd(DAY,+-1,+GETDATE())+and+order_date<=GETDATE()|code-block|syntax|javascript|1384786|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In SQL Server (For last 24 hours):

<pre><code>SELECT *
FROM mytable
WHERE order_date &gt; DateAdd(DAY, -1, GETDATE()) and order_date&lt;=GETDATE()
</code></pre>

I am looking for a <code>where</code> clause that can be used to retrieve records for the last 24 hours?

How to select records from last 24 hours using SQL?

SQL Server

PostgreSQL

SQLite

MySQL

我正在寻找一个where子句，可以用来检索过去24小时的记录？

问如何使用SQL从过去24小时中选择记录？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用SQL从过去24小时中选择记录？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用SQL从过去24小时中选择记录？
EN