Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 A Date Column From Oracle

Author  Topic 

Sep410
Posting Yak Master

117 Posts

Posted - 2008-05-06 : 10:58:20
Hi,

I have a column in my database which came from Oracle database. In this Column I have date but the format is strange for me (Example: 105046).How can I convert this date to MM/DD/YY format in sql 2005?
Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-05-06 : 11:14:55
Cross post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102296



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -