> if you want english format, i suggest style 103
>
> and just how do I do this?
select convert(char(10),yourDate,103) from yourTable
> Yes. I entered the ISO format and it still gave me the American format
> MM/DD/YYYY
so the problem is output
http://msdn.microsoft.com/library/en-us/tsqlref/ts_ca-co_2f3o.asp
did you know you can download BOL (Books OnLine) from microsoft? i think
it's 32 megs or something, sorry i don't have the url at the moment...
finding stuff on their site is torture
rudy