Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Unknown Unknown Unable to convert date into smalldatetime RE: Unable to convert date into smalldatetime

  • July 16, 2009 at 9:02 pm

    #1025977

    Try this

    SELECT CAST (floor (cast(getdate () AS SmallDatetime )) AS