Date data type in Asp.net using C#

Question

Hi 
I'm doing my project in asp.net using C# and sql server 2008.
when i display the information in grid view by default it show the time value as 04/19/2014 12:00:00 AM  how to change it to current system time, Or i no need to display the time in that grid view. please help me.
My Table created format is
create table sigup(id int, name varchar(20), date date, address varchar(50));
pls share the solution in for this
my mail id [email protected]
thank you
karthigeyan.S