LISTING 2: Datetime Expressions That Return an Error
SELECT DATEPART(month, getdate()) + ':' +
   DATEPART(day, getdate()) + ':' +  
   DATEPART(year, getdate())

-- or   SELECT MONTH(getdate()) + ':' +
             DAY(getdate()) + ':' + 
             YEAR(getdate())