SQL 2005 MM-DDD-YY format
To format a date as MM-DDD-YY Today: REPLACE(right(UPPER(convert(varchar(20),getdate() ,06)), len(convert(varchar(20),getdate(),06))), ‘ ‘, ‘-‘) to get Yesterday’s date: PRINT REPLACE(right(UPPER(convert(varchar(20),getdate()-1 ,06)), […]