pcouas_1 Posted March 10, 2016 Share Posted March 10, 2016 Hi,I have an Date in my query and i want replace date by special label for quarter month.I have tried with CASE without succes !An idea regards ? ( "(CASE TO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) WHEN '1' THEN 'First Qtr' WHEN '2' THEN 'Second Qtr' WHEN '3' THEN 'Third Qtr' WHEN '4' THEN 'Fourth Qtr' end)"I need to use this new label in crossTab column and in lineChart Column too RegardsPhil Link to comment Share on other sites More sharing options...
pcouas_1 Posted March 11, 2016 Author Share Posted March 11, 2016 That' ok with decode functionResolved Link to comment Share on other sites More sharing options...
szaharia Posted March 11, 2016 Share Posted March 11, 2016 Try to run your query in a separate DB first and see if it runs successfully. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now