Hi isuru,
You can get only Date from DateTime using SQL as well C#
SQL
DECLARE @Date DATETIME
SET @Date = GETDATE()
SELECT CONVERT(VARCHAR,@Date,103)
C#
DateTime datetime = DateTime.Now;
string date = datetime.ToString("dd/MM/yyyy");
//OR
string date = DateTime.Now.ToShortDateString();
I hope this will help you out.