pat.mclean

 Profile Answers by pat.mclean Questions by pat.mclean

• Jun 9th, 2006

 

If your database consist all dates something like 01/02/2000 or 01-Feb-2000, you will need to break the date field into year, qtr,month & if required date.

to do this, create a class named TIME, under that create new object, in it's select box use oracle's date functions to get required information.

For E.g. : to_char(sales_date, 'YYYY') for getting only year from the date.

similarly, for quarter you can use to_char(sales_date, 'Q')

& for month to_char(sales_date, 'MM') for month number, instead of 'MM' if you use 'MON' it will return you abrevations like Jan for January & so on. for full name of month use 'MONTH'

Cheers,

Pat.

Adi

• Jun 9th, 2006

 

Pat,

Do i need to have some tabel selected like u have mention sales_date? 

pat.mclean

 Profile Answers by pat.mclean Questions by pat.mclean

• Jun 14th, 2006

 

well adi,

it is not a table name, but column name(sales_date).It can be any name depending upon your ETL process & naming convensions. if you have the database ready & you want to break your dates in discussed format, will you process each & every entry from database? certainly not...so simply put a column name ...the column that holds your dates.

you can try the discussed sytax using sysdate (oracle's keyword for current date) 

syntax : to_char(sysdate, 'YYYY') from dual; 

            to_char('01-Jan-2006', ''YYYY') from dual;

where dual is inbuilt table in Oracle.