Yes, use date and time formatting expressions. For example, "MMM d, yyyy"
will produce Aug 27, 2006.
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"psycho" <pa***********@gmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
in sqlserver in date is stored in a particular format. Date and time
are stored in same column. so if i want to display only date or only
time in the datagrid is there any solution?