Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nemohm
Yak Posting Veteran
69 Posts |
 Posted - 2003-04-28 : 15:14:36
|
| I 'm wondering what is the way to specify periods smaller then a day(1 hh, 1min)in WHERE clause in a query?Actually my goal is to get every row that appeared in the last 1 hour; or last minute:Select *From tableWhere logstamp IN …. – one hour period in the past from this moment (column logstamp is datetime)Thx,Dobby |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-28 : 15:22:43
|
| Duplicate post:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25749[/url]Tara |
 |
|
|
|
|
|
Hourly data retrieval