Monthly Archives: October 2013

Ant with Flex

Finding a valuable information about a topic in internet world is not easy… Following links are valuable and will be useful in context of ant integration with flex.

http://www.coderanch.com/t/506388/tools/failed-create-task-type-undefined

http://klevshova.wordpress.com/2010/11/26/installing-ant-in-flex-builder-3/

https://code.google.com/p/cairngen/

http://iamjosh.wordpress.com/2008/08/11/adding-ant-to-flex-builder-3/

ORACLE- Date, Day, Month, Year Queries

How to get first day and last date of week, month, quarter, year in Oracle

 --First day of current week(sunday)
 select TRUNC(SYSDATE, 'Day') from dual;
 --First day of next week(sunday)
 select TRUNC(SYSDATE+7 , 'Day') from dual;
 --First day of previous week(sunday)
 select TRUNC(SYSDATE-7 , 'Day') from dual;
 --First day of current month
 select TRUNC(SYSDATE , 'Month') from dual;
 --First day of previous month
 select TRUNC(TRUNC(SYSDATE , 'Month')-1 , 'Month') from dual;
 --First day of next month
 select TRUNC(LAST_DAY(SYSDATE)+1 , 'Month') from dual;
 --First day of current year
 select TRUNC(SYSDATE , 'Year') from dual;
 --First day of previous year
 select TRUNC(TRUNC(SYSDATE , 'Year')-1 , 'Year') from dual;
 --First day of next year
 select ADD_MONTHS(TRUNC(SYSDATE , 'Year'),12) from dual;
 -- First Day of Current quater
 select TRUNC(SYSDATE , 'Q') from dual;
 -- First Day of Previous Quarter
 select ADD_MONTHS(TRUNC(SYSDATE , 'Q'),-3) from dual;
 -- First Day of Next Quarter
 select ADD_MONTHS(TRUNC(SYSDATE , 'Q'),3) from dual;</code>

--Last day of current week(sunday)
 select TRUNC(SYSDATE, 'Day')+6 from dual;
 --Last day of next week(sunday)
 select TRUNC(SYSDATE+7 , 'Day')+6 from dual;
 --Last day of previous week(sunday)
 select TRUNC(SYSDATE-7 , 'Day')+6 from dual;
 --Last day of current month
 select LAST_DAY(TRUNC(SYSDATE , 'Month')) from dual;
 --Last day of previous month
 select LAST_DAY(TRUNC(TRUNC(SYSDATE , 'Month')-1 , 'Month')) from dual;
 --Last day of next month
 select LAST_DAY(TRUNC(LAST_DAY(SYSDATE)+1 , 'Month')) from dual;
 --Last day of current year
 select LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE , 'Year'),11)) from dual;
 --Last day of previous year
 select LAST_DAY(ADD_MONTHS(TRUNC(TRUNC(SYSDATE , 'Year')-1 , 'Year'),11)) from dual;
 --Last day of next year
 select LAST_DAY(ADD_MONTHS(TRUNC(TRUNC(SYSDATE , 'Year')-1 , 'Year'),-13)) from dual;
 -- Last Day of Current quater
 select LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE , 'Q'),2)) from dual;
 -- Last Day of Previous Quarter
 select TRUNC(SYSDATE , 'Q')-1 from dual;
 -- Last Day of Next Quarter
 select LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE , 'Q'),5)) from dual;