I am storing a date in sql as a smalldatetime. When my asp application retrieves it and puts it in a datagrid it shows the date and the time. (i.e. 8/12/2004 12:00:00 AM). The time is always 12:00:00 AM since no time is given to the server. I dont want to see the time. Is there a statement i can add to the view in sql to prevent this? or some code in asp i can add?

I use enterpise manager. I think the sql version is 8 or something.

Hi there,

If you want to do that in SQL, try this. I am not sure, if you are referring to ASP/ASP.NET. I assume you are working with ASP.Net
Then you got to use this formating expression for the datagrid.
{0:MM-dd-yyyy}
OR
{0:D} as Dataformatting expression

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Vijay-
Formatting for datagrid works fine as told by you earlier, but with SQL SELECT command, convert function does not work. It still shows the time with the date. I have been chasing this problem since 2 weeks.

Thanks
Renu

Renu, I have replied you in another post. Probably you can leave out that thread and continue here on that.

Looked like you were missing a closing bracket in convert function in the other post. Did you verify that?

_________________________
- Vijay G
Strive for Perfection

Ya, that was just a typo. The statement is

select convert(char(10),workdate,101) from tbl_jurisdiction.

Hi,

In place of char, varchar is a better option. I mean in that way you need not have to truncate the value everytime.

Thanks,

Lalit
Life Means More...;)