DATE Convert into only Date and Time is 00:00:00

Question

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

Manikavelu Velayutham · Answer

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'

Jitendra Patel · Answer

thanks  Your Query is very use full to me... Again Thank U

Jitendra Patel · Answer

Thanks a lot................. And another question is date compare validation in asp.net.