Delaneys.Space

SQL Short Date

2012-11-26 13:51:00

Get the month name in a short format

DECLARE @monthList CHAR(48) = 'Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec '

DECLARE @iMonth INT  = 1

SUBSTRING( @monthList,
           @iMonth*4 - 3, 3 )

Get the current month

SUBSTRING( @monthList,
           DatePart(mm, GETDATE())*4 - 3, 3 )

SQL SQL Date SQL Snippet