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 |
AnaBanana
Starting Member
2 Posts |
Posted - 2006-05-24 : 03:33:57
|
Hi,I'm writing a query which will look at a datetime stamp and needs to look at only yesterday's date (not time). Can you provide some advice please?Thanks heaps, Ana :) |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-24 : 04:14:35
|
[code]Select columns from yourTableWhere Datecol>=DateAdd(day,Datediff(day,0,getdate()),-1)and Datecol<DateAdd(day,Datediff(day,0,getdate()),0)[/code]MadhivananFailing to plan is Planning to fail |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-24 : 04:15:04
|
[code]where datecol >= dateadd(day, datediff(day, 0, getdate()), -1) -- yesterday 00:00and datecol < dateadd(day, datediff(day, 0, getdate()), 0) -- today 00:00[/code] KH |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-24 : 04:16:04
|
Again ! KH |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-24 : 04:18:46
|
quote: Originally posted by khtan Again ! KH
Now-a-days you are typing slowly MadhivananFailing to plan is Planning to fail |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-24 : 04:26:13
|
"Now-a-days you are typing slowly"I blame it on the keyboard KH |
|
|
AnaBanana
Starting Member
2 Posts |
Posted - 2006-05-24 : 20:12:11
|
Thanks heaps guys :) |
|
|
|
|
|
|
|