I have a date column , from which it has to calculate quarter end date for each date value. The values are stored in datetime format.
Thanks in Advance.
This should work. Most of the calendar related coulmns can be fetched from Sys_Calendar.BusinessCalendar table. This is tested in TD 14.10.
Below is the query.
Sel QuarterEnd as "Date_Want" from Sys_Calendar.BusinessCalendar where calendar_date=TO_CHAR(TO_DATE ('01Jan2015' , 'DDMonYYYY'), 'YYYY-MM-DD')
Output of the date can be casted to your required format.