• Hugo Kornelis (3/11/2013)


    Dave62 (3/11/2013)


    I'm thinking about including a question like this in an interviewing process.

    I don't agree. I happened to know this one because I was already using SQL Server at the end of the previous century (wow, putting it like that really makes me feel old!) But how many people who started using SQL Server more recently would know this? I would be perfectly fine with employees who frankly admit that they'd have to look up (or experiment) to predict what SQL does with a two-digit year. And if I found someone who did know this, I'd still want to know if (s)he has been keeping up to date, or is still on knowledge of SQL 7.0 and SQL 2000 only.

    Maybe if response "I'm not sure how MSSQL treats two-digit years but I can look BOL" is OK.

    You are right, this behaviour is from a museum.



    See, understand, learn, try, use efficient
    © Dr.Plch