I need help with calculating end of quarter date from "YYYYQ" format.. For example "2017Q1" should be converted to '2017-03-31' date.
Thanks in advance,
Solved! Go to Solution.
You can try something like this.
SyntaxEditor Code Snippet
SELECT EXTRACT ( YEAR FROM DATE)||'Q1',TD_QUARTER_END(DATE,'COMPATIBLE')