Dts and Dates

[Taftheman]

Hi as i live in britain it would be nice if i have my dates as dd/mm/yyyy not mm/dd/yyyy

I have an import process and it all begins when i use a dts package to import the access data into sql. The problem is the dates keep changing to the american version, is there a way i can tell the dts to use a british version for the dates

Thanks in advance

[iburyak]

You can create character string column on database side and it should not change dates then.

Also in select statement you can use convert function with desired style.

See help for different styles available in convert function.

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

Ex.
select convert(varchar(20), cast('12-27-2006 12:00' as datetime), 6)