Hmmm, maybe we should have a...

Glad I could help.

Oops, sorry I'm going the wrong way.

I have tried Christopher's procedure and it does work as expected for me. Could you please supply data in the form of Insert statements that demonstrates the failure that...

Yes, XML does not fully support datetime conversions in SQL 2005 (fixed in 2008, I think). I always just do the date to/from text conversions in SQL, outside of...

Sure:

Select Convert(Varchar(10), Getdate(), 121)

121 covers so many different things that I need/use from dates that I almost always use it, just because it's less things that I have to remember.

Um, very important question: does every line in these text files have the same number of fields(commas)?

aswanidutt.dasara (12/26/2008)

---

hi all

i want to migrate the database from sqlserver2005 to oracle 10g. I have migrated the tables,indexes,views,sequences,triggers through swisssql tool. now i want to migrate the stored...

Umm, well, I really enjoyed meeting you at PASS 08?

🙂

I think that you need to be more explicit about what "it doesn't work" means.

Huh. and here I always use 121.

Hmm, I thought that Jeff already had written the Dates article...?

Yes.

Jeff Moden (12/31/2008)

---

RBarryYoung (12/31/2008)

---

True, but that's not "SQL" so much as it is an implementation artifact of T-SQL and SQL Server. And it's got so many conditions on it...

If you want to avoid modifying the vendor's database, then that is your only choice.