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 |
|
jcsacto
Starting Member
2 Posts |
 Posted - 2008-03-18 : 18:47:08
|
| I'm trying to filter out timestamps that land exactly at .000 milliseconds. (e.g. 2007-12-05 16:30:50.000) Do I have to convert the timestamp to a string first and then use the LIKE statement? If so, can somebody show me how. I'm pretty green to SQL but know the basics. Any help would be greatly appreciated! |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-03-18 : 18:55:15
|
| WHERE DATEPART(ms,yourdatehere) = 0Jim |
 |
|
|
jcsacto
Starting Member
2 Posts |
Posted - 2008-03-24 : 18:44:19
|
| worked like a charm! Thanks Jim! |
|
|
|
|
|
|
Finding specific millisecond timestamps