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 |
|
missMac
Posting Yak Master
124 Posts |
 Posted - 2008-11-21 : 10:31:35
|
| Hello guys,how do i get the last transactions executed in the last 24 hours.Am tryingwhere transactiondate = getdate() thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-21 : 10:34:49
|
| [code]where transactiondate > dateadd(hh,-24,getdate())[/code] |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-11-21 : 10:35:07
|
| between dateadd(hour,-24,getdate()) and getdate() |
|
|
|
|
|
|
how do i get last transactions executed in 24h