Home Forums SQL Server 2008 T-SQL (SS2K8) Missing Century in Date RE: Missing Century in Date

  • August 9, 2014 at 5:33 am

    #1736598

    SQLSeTTeR (8/9/2014)

    My apologies.

    It's a DOB field being stored as a string. No application is pointing to this data.

    Any help is much appreciated.

    First, do not store dates as strings. Use the appropriate data type, and since you appear to be on SQL Server 2008 that would be DATE.

    So you have an entire database with one table storing DOBs, why?