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 |
|
Vadivu
Starting Member
31 Posts |
 Posted - 2008-10-07 : 08:06:12
|
| Can anyone please help me in getting the current date with time part as 00:00:00.000 irrespetive of the current time? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 08:08:10
|
| SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0) |
 |
|
|
Vadivu
Starting Member
31 Posts |
Posted - 2008-10-07 : 08:12:47
|
| thank you so much |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 08:13:52
|
welcome  |
|
|
|
|
|
|
getdate with time part as 00:00:00.000