• It's useful to try to answer to such questions...:-)

    You may find out that

    SELECT CONVERT(DATETIME,'2009-01.01') and

    SELECT CONVERT(DATETIME,'2009-01-01')

    both work...:-)