SQL datetime problem

[xphantg0d]

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?

 

[tim_m]

what flavor sql?

 

[xphantg0d]

I dont know, I just use it. I use enterpise manager. I think the sql version is 8 or something.

 

[Hartlove]

It's not very pretty:

 <%= datepart("m",now()) & "/" & datepart("d",now()) & "/" & datepart("yyyy",now()) %>

Replacing the now()'s with your date value...

I think there's a more elegant way of doing it, but I've moved over to CF, and I'm slowly forgetting my ASP...

 

[Cardboard Hammer]

CONVERT(varchar(10), [smalldatetime_field], 101)