79188757

Date: 2024-11-14 12:39:36
Score: 3
Natty:
Report link

this was an interesting question to solve Hope this answer helps

Select left(datename(month,date_col),3)+'-'+right(datename(year,date_col),2) from table_name

Reasons:
  • Low length (1):
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Sam Johnraj