var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Convert Date to Month
I am new to SQL am trying to convert the dates from a table to months and year in a sql query
Table name is
Field is called Sales Date
I want to convert the Sales Date to Month to work out monthly sales
really? with a space in the column name?
Originally Posted by Hemish
what is the DATATYPE of this column?
Sorry i figured it out it was simple. The field name was called TBI_DATE was just using sales date as an example
select DATENAME(MM, dbo.ASC_TBI_TBL.TBI_DATE) as month
Thank you for having a look