Home Forums SQL Server 2008 SQL Server Newbies Error in Drop Create stored procedure. RE: Error in Drop Create stored procedure.

  • April 28, 2014 at 1:51 pm

    #1709265

    That's the same link I posted. 111 is the code referenced as Japan's standard which is defined as yyyy/mm/dd. That's not exactly yyyy-mm-dd.

    Dutch language uses the format dmy, so that shouldn't be an issue and the format you're using is the ISO standard.

    What happens when you run this code?

    SELECT CONVERT( char(20), CONVERT( datetime, '2014-04-08'))

    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