Hi All,
Could any one tell me how to insert data in table like::
INSERT INTO dim_period (col_name) values (another_query)
Want another query like
select extract(month from calendar_date) from dim_period
here table is same, but i want dayName, day, month, week in month, week in year from date column
so that i want insert query for above task.