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 |
|
dtong004
Constraint Violating Yak Guru
281 Posts |
 Posted - 2001-06-27 : 10:14:46
|
| The getdate() gives the current date and time. If a table has a datefield and stamped with system date. Let us say, some records are stamped with today. '06/27/01'.However, if query the table with where recorded_date=getdate(). It never worked. The reason is getdate() contains time also. It will return zero rows. Anyone have good idea how to get around. I want the records exact on that date no matter what time. And I don't like the idea that use "between getdate()-1 and getdate()".ThanksDaneil |
|
|
|
|
|
getdate() question