Home Forums SQL Server 2008 SQL Server 2008 - General Concatenate + Datetime conversion error RE: Concatenate + Datetime conversion error

  • March 31, 2015 at 10:20 am

    #1787785

    Why are you concatenating the date with itself? What are you trying to do?

    There's no problem concatenating dates if you use CONVERT()

    DECLARE @SampleData TABLE(

    SomeDate date)

    INSERT INTO @SampleData

    VALUES(GETDATE()),(GETDATE() - 1),(GETDATE() - 2),(GETDATE() - 3),(GETDATE() - 4)

    SELECT CONVERT(char(10), SomeDate, 120) + ';' + CONVERT(char(10), SomeDate, 120)

    FROM @SampleData

    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