Archives: 03/22/2012

HOW TO CALCULATE

– Percentage variance  = (New /Previous – 1)*100 (%) – Gross Margin Percentage  = (Revenue- Costs) / Revenue * 100 (%) – Standard deviation =√(1/N ∑(xi-xmedia)² )

MANAGE DATE

Oracle date format With the functions to_char and to_date, a date format can be used. Example: select to_char(sysdate,’DD/MM/YYYY HH24:MI:SS’) from dual; will return something like: 24/03/2006 14:36:43 Here is a list of all the formats that can be used: Format mask Description CC Century SCC Century BC prefixed with – YYYY Year with 4 numbers…

Go Top