Home Forums SQL Server 2014 Administration - SQL Server 2014 Problem Converting DATE. Trying to Purge Data Oldest than 30 days from Performance Counter Table where date column is char (24) RE: Problem Converting DATE. Trying to Purge Data Oldest than 30 days from Performance Counter Table where date column is char (24)

  • Lynn Pettis - Friday, August 10, 2018 8:41 AM

    Could you post the complete error message you get regarding the conversion failure?  Also, what is the date format on your system, is it mm/dd/yyyy or dd/mm/yyyy?

    Hi Lynn

    The error:
    Conversion failed when converting date and/or time from character string.

    The server Date Format:
    dd/MM/yyyy