hey

you can try this way its easy know..

Select convert (varchar, getdate(),101)

regards

balram

declare @date datetime

set @date = '16/Aug/2004 1:05:00 PM'

select convert(varchar(11),@date, 113) AS ISO

with in the andy suggestion itself if we specify the no of char we want to get from the...