Forum Discussion
Questions about converting date
I used a function to convert character to date and then do a calculation using datediff. ,CONVERT(DATETIME,CONVERT(CHAR,cs.LastCourseActivityDate)) AS Last_Course_Activity_Datetime ,case ...
That's really to less on information.
Please post table design as DDL, some sample data as DML statement and the expected result.