This content has been marked as final. Show 2 replies
I am misunderstanding your question but i think this will help you. Try:
alter session set nls_date_format = 'dd/mm/yyyy hh24:mi:ss';
Also instead of creating dynamic table to maintain particular month data, use table range partitioning on date column. Then you can simply select rows for particular month with:
select * from your_table partition (partition_name_for_required_month);
This will prevent duplicating of data and increase query performance when searching for particular period.