varchar to datetime

Question

varchar to datetime

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004392 More actions · Answer 1

The_SQL_DBA (9/29/2008)
When I put forth the idea and the risk involved in doing this conversion to management, they said they were better off without doing it. The reason being the hundreds of client side applications that hit the DB use the current format of date. They cannot bring it all together and be assured what the change they are trying to make will keep things in place...so we have scrapped this idea for we don't know what the effect could be....
thanks again guys!!!

"Hundreds" of applications??? 😛 Even Bill Gates doesn't have "Hundreds" of applications. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Is it better to scrap the plan rather than make the change and see what breaks then fix it?

😎