Home Forums SQL Server 2008 T-SQL (SS2K8) Argument data type datetime is invalid for argument 1 of substring function RE: Argument data type datetime is invalid for argument 1 of substring function

  • Why not use DateName function instead of using case conditions !!, as the datatype of column you are checking is datetime.