this question has answer here:
- sql server string date conversion 9 answers
how convert date mm/dd hh/mm
example: 04-05 12:42
since on sql server 2012, use format:
select format(getdate(), 'mm-dd hh:mm') 
this question has answer here:
how convert date mm/dd hh/mm
example: 04-05 12:42
since on sql server 2012, use format:
select format(getdate(), 'mm-dd hh:mm')
Comments
Post a Comment