Hi All,
Please Help Me.
IN SQL Server I want to this output
In put :12/8/2010 4:13:55 PM
This is my input I want to below OUT PUT
12/8/2010 0:00:00
THANKS,
JITENDRA PATEL
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jitendra PatelPosted Mar 31, 2011, 4:05 AM
Again Thank U
Jitendra PatelPosted Dec 8, 2010, 8:28 AM
And another question is date compare validation in asp.net.
Manikavelu VelayuthamPosted Dec 8, 2010, 6:03 AM
select Convert(varchar,DATEPART(M,'12/8/2010 4:13:55 PM'))+'/'+Convert(varchar,DATEPART(D,'12/8/2010 4:13:55 PM'))+'/'+Convert(varchar,DATEPART(YYYY,'12/8/2010 4:13:55 PM')) +' 0:00:00'