471,071 Members | 1,357 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,071 software developers and data experts.

Dts and Dates

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
Dec 4 '06 #1
1 1213
iburyak
1,017 Expert 512MB
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)
Dec 4 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by Riley | last post: by
7 posts views Thread by Alistair | last post: by
5 posts views Thread by PW | last post: by
10 posts views Thread by Colin Steadman | last post: by
1 post views Thread by Don Sealer | last post: by
2 posts views Thread by Rachel Suddeth | last post: by
1 post views Thread by pitfour.ferguson | last post: by
7 posts views Thread by evilcowstare via AccessMonster.com | last post: by
2 posts views Thread by Jim Carlock | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.