SQLServerCentral » Latest topics
Get the year and Qtr
Ia am trying to get the year and Qtr from my date column which has values like- YYYY-MM (2017-02). I want the Year and Qtr as -2017 Q1
I tried below- select CONVERT(datetime, '2017-02',104) as Col1
it gives me Conversion failed when conv
I tried below- select CONVERT(datetime, '2017-02',104) as Col1
it gives me Conversion failed when conv
No comments:
Post a Comment