Home Forums SQL Server 2008 T-SQL (SS2K8) Decimal to DateTime2 conversion SQL SERVER 2008 help RE: Decimal to DateTime2 conversion SQL SERVER 2008 help

  • I can see that you're new in here. I really would like to help you but there's nothing I can't do unless you give me something to work with. I can't see your data and just have an idea on what the problem it could be, but it's just a shot in the dark.

    Please read the article about Forum Etiquette linked in my signature.

    My guess is that there's problem with the data stored in your table (that's why it's a best practice to use the correct data type). Use the queries I gave you to find which are the rows that don't have a valid format.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2