Tuesday, February 21, 2012

Returning Date without

Hi
I have a simple select like this
Select MyDate, MyID From Sales
The select is returning the date like this:
01/06/2005 12:00:00 a.m.
02/06/2005 12:00:00 a.m.
I'm showing it on a Datagrid in my app, my question is can I modify the
select to return only the date without the time part, like this
01/06/2005
02/06/2005
Thks.See the CONVERT function as its arguments in SQL Server Books Online
Anith

No comments:

Post a Comment