Teradata SQL syntax from date to quarter

datesyntaxteradata

I need Teradata SQL syntax to extract quarter from a date:

Date: (YYYY-MM-DD)
2015-09-12
2015-05-22
2014-12-15

Given below is the expected output:

3Q15
2Q15
4Q14

Query which I have tried (wrapped for readability):

SELECT DATE, ((CAST(EXTRACT(MONTH FROM DATE) AS BYTEINT)-1)/3)+1 
    || 'Q' || substring(DATE,3,2) quarter

Error:

Missing parameters

Best Answer

Teradata supports Oracle's TO_CHAR syntax since TD14:

TO_CHAR(date, 'q"Q"yy')

Related Solutions

Need help with SQL query in Teradata

Seems like you need a conditional sum based on CASE:

select member_number,
   sum(case when social_activity = 'challenges' then step_count else 0 end) as challenges,
   sum(case when social_activity = 'posts' then step_count else 0 end) as posts
from ABC
group by member_number

Unable to execute the Teradata stored procedure due to syntax errors

Teradata doesn't support CTE in stored procedures (as of 15.00), see SQL Data Manipulation Language > The SELECT Statement > WITH and WITH RECURSIVE Statement Modifiers. Surprisingly, in some cases WITH works, but in more complex cases you get a syntax error like that.

Best Answer

Related Solutions

Need help with SQL query in Teradata

Unable to execute the Teradata stored procedure due to syntax errors

Related Question