SQL Server Max Datetime format

convert(datetime, max(ul.date), 101)  doesn't convert the datetime.  what does?
Who is Participating?
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Try this one:

convert(Char(10), max(ul.date), 101)
Nathan RileyFounderCommented:
select cast(max(ul.date) as datetime)
from table
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.