all groups > sql server programming > june 2005 >
You're in the

sql server programming

group:

Returning Date without


Returning Date without Kenny M.
6/10/2005 6:26:01 PM
sql server programming:
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.
Re: Returning Date without Anith Sen
6/10/2005 10:39:04 PM
See the CONVERT function as its arguments in SQL Server Books Online

--
Anith

AddThis Social Bookmark Button