thank you much all.....
in this instance it is a client side web page building a query string user
enters standard date
so convert() work gr8 for the 1st 10 chars.....

have a gr8 day
thanks again
dave p


"davep" <dvs_bis@sbcglobal.net> wrote in message
news:fQeSg.16681$IA.2714@newssvr11.news.prodigy.co m...
> hi, is there a function in ms-sql to get the date only from a datetime
> column
>
> example
> column 2006-09-26 00:00:00
>
> i would like to see 2006-09-26
>
> tia
> Dave
>
>